Hi
I created SSIS Package to transfer tables from one sql2005 DB to another sql2005 DB.
When I execute the package from the BIDS it execute succesfully.
However, when I import the package (file system) to the management studio - msdb - stored packages and run the package from there (right click: Run Package) I get this error:
the validate method on the task failed, and returned error code. the validate method must succeed and indicate the result using an out parameter.
what is the reason for this error?
I aprriciate your help.
SeoAndSo.com
Enable logging and see what are the validations failed. Probably it will be database connections you are using.
Thanks
Thanks for your answer.
I enabled login and got this error now:
Code Snippet
Executed as user: NT AUTHORITY\NETWORK SERVICE. ...00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 9:24:21 AM Error: 2007-08-08 09:24:22.28
Code: 0xC0202009 Source: TestPckg5 Connection manager "server2.MySourceDB.MyDBUser"
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred.
Error code: 0x80040E4D. An OLE DB record is available. Source:
"Microsoft SQL Native Client" Hresult: 0x80040E4D Description:
"Login failed for user 'MyDBUser'.". End Error Error: 2007-08-08 09:24:22.28
Code: 0xC020801C Source: TestPckg5 Log provider
"{8C4BDB79-EEE9-4280-B15E-4E63B4B683DF}"
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.
The AcquireConnection method call to the connection manager "server2.MySourceDB.'MyDBUser'"
failed with error code 0xC0202009. There may be error messages posted before
this with more information on why the AcquireConnection method call failed.
C... The package execution fa... The step failed.
How can I fix the error. I'm not familiar with SSIS so much.
Thanks.
|||The error says login failed for user "MyDBUser". Check the login credentials, if you are using package configuration check the configuration file. Since SSIS does not store the password in the configuration file, you will need to manually enter the password in the configuration file.
Thanks
|||
the user name and password for the package are correct. the package is running good from the BIDS. only when I run it in a job from the sql manamgement studio it fails. I didn't define configuration file for the job. what should be in this file. how do I do it. I'm not familiar so much with SSIS. can u give me an example of a configuration file, and explain how to configure it to this job?
Appriciate your help.
|||
I found the problem. I change the protection level for the package to 'rely on server storage and reles..'.
now it works.
No comments:
Post a Comment