Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2007-11-06 : 09:14:32
|
| Hi,I am trying to create a job to run a ssis package.The job fails. Looking at the history log, there is no proper information on why the job failed. It just says: The job failed. The job was invoked by user ...please note that the ssis package runs fine on it's own i.e. in the designer by pressing the run button.Thanks |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-11-06 : 13:43:08
|
| Well, there are many things to look for.What is the authentication, windows or sql? Does it use a config file? What are the settings there? Did the pkg log anything that might help?And, how did the pkg get to the server? |
 |
|
|
jcumberland
Starting Member
8 Posts |
Posted - 2007-11-06 : 22:30:20
|
| A SQL Agent job doesn't capture the SSIS package output, so the logging needs to be handled by the package itself, but I think this can be done in the job step properties as well if you have an existing database connection set up in the package. Then you just look in sysdtslog90 for the output. I'm not sure if you would see any rows if there were validation, not execution, errors though. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-06 : 22:31:51
|
| If remote file involved in the package, check sql agent service account's permission. |
|
|
|
sqlvinoth
Starting Member
1 Post |
Posted - 2010-03-09 : 10:07:37
|
| Hi, I have a problem in executing a job,when i tried to execute the package it is fine but,if i tried the same package through job then the job is getting failed and in the log it show an error at sequence container which i have in that package.But it is executing fine when i execute through the ssis environment. And there is no access problem i have checked that very well.I really don't understand why its getting failed and i had spend 2 days almost for this.So could any one plz help me out in this issue.I have one more package similar to that,but that is getting executed through job.Am totally confused.Vino |
|
|
|
Reginajosephine
Starting Member
4 Posts |
Posted - 2010-03-18 : 19:08:53
|
| When you save the package to the server you need to specify Server storage so the package will get the credentials from the server. Go to visual studio and save it to your server and select the last option under Package protection level (Rely on Server Storage and Roles for Protection Level) this should fix it.Regina Beauregard |
|
|
|
|
|
|
|
|
ssis job failed