Hi,

I have created a SSIS package that copy some tables from one SQL Server to
another. If i run the package in Integration Services it runs OK. If i create
a Job to run the package it gives me an error (The package execution failed.
The step failed.) each time i try to run. Any idea?

Thanks,
Rui Reis

Hello Tecnica,

More than likely permissions and execution account. What job step type are
you using? Try using an Operating System step and that should give us some
better output to figure out what os going on.



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Hi Rui,

Welcome to use MSDN Managed Newsgroup support. And thanks Allan's great
suggestion.

From your description, my understanding of this issue is: You can run your
SSIS package in Integration Services but can not run in a job. If i
misunderstood your concern, please feel free to point it out.

Bases on my research, you may first check you SQL Agent Account.

What is your SQL Agent Account? What authentication mode you use to connect
to the remote SQL Server in SSIS package? Windows or SQL ?

If the SQL Agent Account does not grant the permission on the remote
server, your job will be fail to connect to the remote server.

Please let me know your result with that i can provide further assistance.
I look forward your reply.

Sincerely yours,

Wei Lu
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Wei

one again right on the target.
Thanks,
Rui Reis

"Wei Lu" wrote:

Hi Rui,

Thanks for the update and glad to hear you resolve the issue.

Have a nice day!

Sincerely yours,

Wei Lu
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.