October 14, 2007 at 6:54 pm
Hi everyone. I’ve created a package and it runs fine,,when launced within integrated services. When I attempt to run a scheduled sql job to launch the package it fails, regardless of what account I use. It keeps attempting to run under the SQL instance service account, regardless of what account I tell it to run under. Anyone have success in creating a SQL job to run a SSIS package? Thanks to everyone for being there to help.
SQL 2005
October 14, 2007 at 10:27 pm
Hi,
Can you check whether the account is having required permission to execute the job?
The user (running sql agent service) should have the proper permission.
DTEXEC /FILE "C:\PackageName.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EW /SET "\Package.Variables[User::SQLInstance].Properties[Value]";"ServerName"
Regards,
Vara.
October 15, 2007 at 12:44 am
You can set the package owner in the Visual studio and if the owner of the package and the account to run the package are same. It will be easy for you to get it work.
October 18, 2007 at 5:07 am
October 27, 2007 at 10:10 am
When you schedule a SSIS package and when it runs as scheduled job , if windows authentication is used inside the package then it will sure take sql server agent service account. If you have called any folder make sure you have right privilege for the sql server agent account.
Pls refer the below link for scheduling package
Regards..Vidhya Sagar
SQL-Articles
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply