SQL/DTS/Job schedule problem...

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Ok..this is a strange one..being a semi-newbie to SQL Server 2000 admin stuff...

At our company...we have sever jobs scheduled to run DTS packages...the jobs were created years ago under the Management/SQL Server Agent/Jobs folder to execute DTS packages. We had a guy leave and all of the sudden passwords got changed on stuff and things just started breaking. The DTS packages only run now if I execute them manually. The jobs failed. The passwords for our SQL server didnt change or passwords for our internal connections to our database within our code didnt change. Why are these jobs failing? Here is the error I'm getting from the jobs:

DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Copy Data from PRODFILE to [CompanyXYZDB].[dbo].[PRODFILE] Step DTSRun OnError: Copy Data from PRODFILE to [CompanyXYZDB].[dbo].[PRODFILE] Step, Error = -2147467259 (80004005) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 Error Detail Records: Error: 5 (5); Provider Error: 5 (5) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 DTSRun OnFinish: Copy Data from PRODFILE to [CompanyXYZDB].[dbo].[PRODFILE] Step DTSRun: Package execution complete. Process Exit Code 1. The step failed.

Our network engineers are way in the dark. Any clue or help here? Thanks.

-Travis

-- Anonymous, January 31, 2002

Answers

guess it was a strange one ;)

-- Anonymous, February 07, 2002

Travis,

It sounds like the account the sql server uses (the user account that the SQL Server service runs under) does not have rights to read the file. This problem could materialize suddendly when the password to that account changes.

Hope this helps,

Eric

-- Anonymous, February 08, 2002


Moderation questions? read the FAQ