Database connectionstring error in Microsoft SQL Server Integration Services (SSIS)

When you use the oledb destination in a SSIS package, you must use the oledb connectionstring syntax, see http://www.connectionstrings.com/sql-server-2008 for more information. If you use the connectionstring: Data Source=Server1\InstanceName1;Initial Catalog=Database1;Provider=SQLNCLI10.1;Trusted_Connection=True;  you wil get the error: "Invalid value specified for connection string attribute” ‘Trusted_Connection’", because the syntax should be Data Source=Server1\InstanceName1;Initial …

SSIS package configuration

We have chosen to use a windows environment variable to hold the path to the *.dtsConfig, which is used to configure the *.dtsx package. – Close all open Microsoft Visual Studio 2005 instances (because changing windows environment variables will have nog effect) – Add a Windows Environment Variable: – start …