Tuesday, February 21, 2012

schedule a ssis job

I created a ssis package on my local developer sql server, the package is to connect to another sql server, and export a view to an excel file and send an email with excel attachment.

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