Universal Data Link defines a data source.
Advantages are portability, so that moving packages from environments is easier since
data source information is stored in the UDL on each machine. For UDLs should you use Windows
or SQL Server authentication? Since the UDL is an unencrypted text file you should use
Windows Authentication otherwise the stored password is not secure.
No comments:
Post a Comment