What is a UDL and what advantages does it have?

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.





Keywords:  ssis interview questions,SSIS Interview Questions and Answers , SSIS interview Questions PDF Download , SSIS Interview Questions for Experienced.
2012 ssis interview questions.