April 23, 2003 at 2:51 pm
I executed this stored proc:
CREATE PROCEDURE RunDTS AS
exec master..xp_cmdshell 'dtsrun /S "test" /U "sa" /P "test" /N "EZRouteCustUpLoadDB" '
GO
and it came back with this error:
DTSRun OnError: DTSStep_DTSDataPumpTask_2, Error = -2147467259 (80004005)
Error string: Error opening datafile: The system cannot find the path specified.
Can anyone tell me what the error is about? What path does it talk about?
Thanks for all the help.
April 23, 2003 at 3:00 pm
Does your DTS package access a file on disk?
If it does, you should check that path.
April 23, 2003 at 3:53 pm
this DTS package involves accessing a tab delimited text file which I stored on my c:\ drive and transform the data into a table.
quote:
Does your DTS package access a file on disk?If it does, you should check that path.
April 23, 2003 at 6:44 pm
Copy that text file to the c:\ of your SQL Server machine.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply