Hello,
I created a ssis package to transfer data between tables of sql2005 DB to another sql2005 database.
when i run it from BIDS with right click -- > execute package i get this error:
Code Snippet
Error: 0xC002F325 at CopyTables1, Transfer SQL Server Objects Task: Execution failed with the following error: "Cannot apply value null to property Login: Value cannot be null..".
anyone can help here.
Thanks.
Check your connection managers... it appears that your login credentials were lost.
|||Thanks for your anwer.
The connection i configured in the ssis package seems good. how do I check the connection managers exactly?
i'm not so familiar with the BIDS.
Thanks.
|||In BIDS, below the main scren palatte there is a tab which is labeled "Connection Mangers". You can check and see which connection manager you are using for the task or transform that failed (by double clicking the task or transform), then double click on the connection manager which is giving you the problem. You should see your connection credentials (provider / server name / authentication / initial catalog / etc...)
click on the "test connection" button in the lower left hand corner.
NOTE: if you are using sql authentication, you will not see your password as SSIS does not store this in plain text.
|||Hi,
Thanks for your answer.
I tested the connection successfully in the connection manager.
I still get this error when I run the pacakge!!
i'm using sql authentication.
No comments:
Post a Comment