> 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

"Wei Lu" wrote:

> 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.
>