Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Connection String Issue for DBAmp from SSIS


We are in the process of upgrading our SQL server and SSIS from 2008 to 2016. In the SSIS jobs, we are using the connection string for DBAmp as below.

VABSAMXYZ02\DEMOXY;Initial Catalog=demo_xyz;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False;

However, when I run the SSIS job, I am getting the below error message.

Execute SF_BulkOps Error: DBAmp is using the SQL Native Client. 16:48:21: Error: Soap headers parameter is improperly formatted. Possible failure reasons: Problems with the query. "Resultset" property not set correctly. parameters not set correctly, or connection not established correctly.

I changed the Provider to DBAmp.DBAmp and that did not work either and I got a different error message "Failed to acquire connection SalesforceSQLDB. Connection may not be configured correctly or you may not have right permissions on this connection".

However, I am able to run the SF_BulkOps command from SSMS successfully.

Can someone help?
1 person has
this question