DTS service, it doesn't start after I applie the MSFT patch

[19902003]

Hi, Can anyone please tell me how to fix this error message? I couldn't scan the packages anymore, also I couldn't start the job under SQL.

Thanks a lot,
-Steve

Executed as user: 123Star\Admin. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Copy Data from pbupfl to [DBPIT].[dbo].[DPAF_DETAIL] Step DTSRun OnError: Copy Data from pbupfl to [DBPIT].[dbo].[DPAF_DETAIL] Step, Error = -2147467259 (80004005) Error string: Error opening datafile: The system cannot find the path specified. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 Error Detail Records: Error: 3 (3); Provider Error: 3 (3) Error string: Error opening datafile: The system cannot find the path specified. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 DTSRun OnFinish: Copy Data from pbupfl to [DBPIT].[dbo].[DPAF_DETAIL] Step DTSRun: Package execution complete. Process Exit Code 1. The step failed.

 

[mrdenny]

Sounds like you don't have access to a file/folder that you are trying to write to.

Edit the DTS package, right click properties. There should be a logging section on one of the tabs. Enable the logging and run the package again.

Then right click on the package and select view log or logs or something like that. That should give you better info about the failure.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[19902003]

Hi Denny,

This is the error that I got form the log:



Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:0


Please help.

Many thanks,

Steve

 

[mrdenny]

Looks like something is blocking access to the SQL Server that you are trying to connect to. Firewall or something? Maybe the Windows Firewall got turned on?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[19902003]

I don't have firewall on windows 2000 server, andy thought?

is there a way to look for the previous job detail, my current job won't run at all, I need to look for the steps or the path of the file

Manny thanks,

 

[mrdenny]

You'll only have log details for after you turned on the logging.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com