September 15, 2015 at 5:44 pm
I created an SSIS package, which is a 2 step procedure where a query is converted into a flat file and that flat file is emailed out to several people. the SSIS package works fine, I also deployed it to the SQL server and ran the package it is also working fine. but when I put it as an agent job it fails.
I tried it with package source (File system as well as SSIS Package store) still fails and only gives me the following error with no description:
"The job failed. The Job was invoked by User DMG\MuffadalH. The last step to run was step 1 (Decline Letter"
It seems to be a fairly easy thing, but wont let me sleep tonight..please help !!
September 15, 2015 at 8:32 pm
Database jobs are run by the SQL Agent. Take a look at the network account the SQL Agent service runs as and make sure it has permission to do what the job does. Also, make sure the account has permission to write to the folder where you're trying to save the flat file.
Next, take a look at the history of the job. There should be a more descriptive error message for the step that should point you in the right direction.
I hope this helps. I'm afraid that I can't take it much farther than the job itself, as I barely know enough about SSIS to even spell it...and I sometimes get that wrong. 😛
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply