October 2, 2007 at 1:23 am
Hi everybody.
I have such problem:
After I move my integration services packege to another machine it failed. I tried to recreate connection manager, but result is the same. If I create a simple SQL task in that package and try to execute it - it fails with info:
SSIS package "Main_Package.dtsx" starting.
Error: 0xC00291EC at Execute SQL Task, Execute SQL Task: Failed to acquire connection "SRV-DSA3.TIA_EXTRACTS_OriginalData.sa". Connection may not be configured correctly or you may not have the right permissions on this connection.
Task failed: Execute SQL Task
SSIS package "Main_Package.dtsx" finished: Success.
But when I create it(SQL task) in the new package - it works perfectly. Maybe somebody could help solving this problem.
Thanks for any information.
October 16, 2007 at 8:28 pm
Can u completely delete the old connection and create the connection with a new name in your transfered pacakage? This might help, worked for me. I think the connection information of old package is still getting transfered with your package and is therefore giving you the error.
October 18, 2007 at 3:18 am
Are u using any dtsconfig files to set the connection properties.
Try right clicking on the package screen and select Package configurations uncheck the box to use package configurations and then try making changes to the connection string. This way the changes wont be overwritten.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply