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 …