Know about Package Configurations in SSIS
How we can make a Package Completely Portable?
As in DTS we maintain couple of UDL, In SSIS it has been made easier to configure a package as an XML string which can be stored into a file or into a table.
Use the Connection String of any Connection Manager for easy maintenance:
A sample configuration file should look like the one below:
For Windows authenticated connection to SQL Server:
For SQL Server authenticated connection to SQL Server:
As in DTS we maintain couple of UDL, In SSIS it has been made easier to configure a package as an XML string which can be stored into a file or into a table.
Use the Connection String of any Connection Manager for easy maintenance:
A sample configuration file should look like the one below:
For Windows authenticated connection to SQL Server:
For SQL Server authenticated connection to SQL Server:
Comments