Job failed executing SSIS package

Question

Post reply

Job failed executing SSIS package

krishusavalia

SSCrazy

Points: 2385
More actions
February 11, 2011 at 8:08 am

#233393

I am using SQL server 2008 integration services.
I created the package which works fine while executing from SSIS manually But when i created the job then its failed.
If I gave local path in the package for extracting the files then its works fine and job success but if i gave the network path then its failed.
I know that its kind of comman problem. I am new in SSIS.
Please guide me with some solution. I tries using the proxy account but stilll its failed.
Thanks In Advance.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

ZZartin SSC-Dedicated Points: 30758 More actions · Answer 1

Does your SQL server service account have proper access to the network path?

John Mitchell-245523 SSC Guru Points: 148786 More actions · Answer 2

ZZartin (2/11/2011)
Does your SQL server service account have proper access to the network path?

In case you have separate accounts for your SQL Server and SQL Server Agent services, it's usually your SQL Server Agent account that needs access to the server path if you're running your package from a job.

Edit - corrected gramatical error

John

krishusavalia SSCrazy Points: 2385 More actions · Answer 3

I am new in to SSIS.

Can you guide me though how can i check that account is same or different for sql server and sql sercer agent?

when i am executing the package mannually from SSIS (BIDS),its running fine.

vani_r14 SSCrazy Points: 2843 More actions · Answer 4

Hi

there is a process of doing this. I have been there a few times and learnt it.. Please find attached is a doc that could help you with the process

Cheers

Vani

John Mitchell-245523 SSC Guru Points: 148786 More actions · Answer 5

krishusavalia (2/11/2011)
I am new in to SSIS.
Can you guide me though how can i check that account is same or different for sql server and sql sercer agent?
when i am executing the package mannually from SSIS (BIDS),its running fine.

This is nothing to do with SSIS. You can check the service accounts using SQL Server Configuration Manager.

Have you fixed your problem? It's courteous when people have taken the time to help you for you to feed back on whether the solutions provided were successful.

John