June 30, 2008 at 11:19 am
I need to execute a JOB that call a SSIS packge but this doesn't work
First I published the SSIS package and then I call it
when I try to execute the job appear an error
i don't know what to do ..
June 30, 2008 at 11:38 am
Perhaps you can post the error.
Don't just post the SQL Job Agent Error, turn on package logging and get the SSIS error.
June 30, 2008 at 11:51 am
When I execute the package from the visual studio 2005 it works correctly. But the problem is when i try to call this package from a new job in sql server agent.
is tehere any special permission to execute a dts from a job ??
June 30, 2008 at 11:55 am
Your SQL Agent account needs to be able to execute SSIS packages. It also needs to be able to access whatever store your package resides in. If you have used NT Authentication, it needs access to the resources the package accesses.
This will be much easier to troubleshoot with the error message. You have to start with getting the error.
June 30, 2008 at 12:04 pm
I just have working some jobs that call to SISS packages and these are working correctly
However , this time is not working
July 1, 2008 at 12:15 pm
You really will get more help if you post the requested information. There are a lot of people on these forums who can and will help, but don't want to waste their time and yours by making guesses about what the problem is.
Greg
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply