February 14, 2013 at 5:10 am
I'm creating an SSIS package which has a script task in it.
In the script task, i have provided the details of connection string and the sql statements to get executed.
The problem is , when i try to execute the package, i'm getting the following error:
"Failed to acquire connection. Connection may not be configured correctly or you may not have the right permissions on this connection."
My connection string is like:
"Data Source=SQLServerName;Integrated Security=false;Initial Catalog=STG_DB;Provider=SQLNCLI10.1;Persist Security Info=True;Userid=uid;Password=pwd;Auto Translate=False;"
However, when I change the "Integrated Security=false" to "Integrated Security=SSPI", the package gets executed successfully..
I'm using Windows 7.
Please let me know your suggestions in fixing this issue...
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply