If I run the package manually it works great.
But now I want to schedule it to run as a job in my local sql server, I cannot make it right.
What I did is:
Create my credential to map to my windows log in
Then create a proxy account to map credential.
Then run the job using my proxy account, but I keep getting errors, . The package execution failed. The step failed.
I cannot get more detailed info.
Please advise.
ThanksThe end of this KB article has instructions for getting detailed info:
http://support.microsoft.com/kb/918760
No comments:
Post a Comment