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

0 Comments

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: