gomz_5
asked on
SSIS : Could not find path (ConnectionManager) while using Deployment Manifest
Hi
I have a package that connects to a SQL server. The package works when I use it in my machine. But when i created the Dtsconfig and DeploymentManifest file and ran it in another machine it threw an error saying path could not be found. The connection string I give is correct that normally connects to the local sql server machine.
Pls help
Thank you
Gomz
I have a package that connects to a SQL server. The package works when I use it in my machine. But when i created the Dtsconfig and DeploymentManifest file and ran it in another machine it threw an error saying path could not be found. The connection string I give is correct that normally connects to the local sql server machine.
Pls help
Thank you
Gomz
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you check the third line from the last, it says that invalid username password..
Kindly provide correct credentials and give it a try..
Kindly provide correct credentials and give it a try..
ASKER
Also when i run the deploymentmanifest file in my own system , I recieve the following error SSIS error code DTS_E_CannotAcquireConnect
It also said there maybe error messages posted before this with more information on why acquireconnection method failed. The actual package at designer also stops working with the same error message when i create the dtsconfig file.
Pls find the error print screen attached.
Error.bmp