Error running Job

Question

Post reply

Error running Job

SQLWannabe

SSCrazy

Points: 2842
More actions
March 20, 2008 at 8:21 am

#180219

I get this error after I've created a job. I've logged on as 2 different users but both times have gotten this error. It appears that it's looking for some temporary file on the hard drive. I have no idea what/why it's looking for this file. Can someone point me in the right direction?
"Could not find a part of the path 'C:\Documents and Settings\ServiceAccount\Local Settings\Temp\2\tmp9.tmp'.". End Error DTExec: The package execution returned DTSER_FAILURE (1).

Viewing 8 posts - 1 through 7 (of 7 total)

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

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 1

I don't have an answer to your question. But maybe you should take a look at the DTS package you are executing.

My blog

Adam Bean One Orange Chip Points: 26631 More actions · Answer 2

Might want to read this ... http://www.file.net/process/tmp9.tmp.dll.html

Mohan Kumar SSCertifiable Points: 5365 More actions · Answer 3

If you are using tmp9.tmp file anywhere in your DTS then refer http://support.microsoft.com/kb/912911

otherwise you may have to refer suggestion posted by Adam.

[font="Verdana"]--www.sqlvillage.com[/size][/font]

SQLWannabe SSCrazy Points: 2842 More actions · Answer 4

OK, talked to my network guy and he suggested backing down from IE7 to IE6. I did that and that seems to have worked. I had to re-created the SSIS package and the job. I ran the job manually twice, so I'll check Monday if the job runs properly or not and if it is still looking for that .tmp file. BTW, thanks Adam Bean for the help on that article, it really helped. I'm sure I would've been lost without it.

SQLWannabe SSCrazy Points: 2842 More actions · Answer 5

Okey dokey, it's Monday and guess what?.......... The job failed because of the same error. I'm quite perplexed. I also cannot run the SSIS package manually because of the same error. All the virus and spyware definitions are in place (and have been) so I'm not sure what the problem is. Any more help? Anyone?

SQLWannabe SSCrazy Points: 2842 More actions · Answer 6

Here's more info. I created the package on the server that will be running the job. The SSIS package is in the MSDB database. After I create the SSIS package, I notice the 7 .tmp files get created. They are associated with data connections in the job when I click on the 'Data Connections' tab for the job. "AllowedToFailPrologueSql" is associated with a .tmp file so is "CompensatingSql" and so is "NonTransactableSql", as are the other 4 "XXXXSql" connection files. I can run the SSIS package and the Job on the day they are created. I assume these files drop off after a certain time period and both the package and job won't run because it's looking for these files. How can I solve this?

sawan.patel1987 Newbie Points: 5 More actions · Answer 7

Just had the same issue

there could be 2 ways

1: just log off the user and log back in and try again

2: administrative rights to the User you are using on that Server/Box