Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesThe DTS package runs fine through Enterprise manager successfully. However, when scheduled through a job that runs the dts through the following code: DECLARE @findfile int Exec @findfile = master.dbo.xp_cmdShell 'dir \\ServerName\folder\ filename.xls', no_output IF (@findfile=0) BEGIN Exec master.dbo.xp_cmdshell 'dtsrun -E -Server\Instance -N"DataImport"' END The servername specified in the above statement in a different server than the server that the package resides on. This is the error that I get when I try to run the same code using query analyzer: DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQ LTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQ LTask_1 DTSRun OnStart: DTSStep_DTSDataPumpT ask_1 DTSRun OnError: DTSStep_DTSDataPumpT ask_1, Error = -2147024893 (80070003) Error string: The system cannot find the path specified. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error Detail Records: Error: -2147024893 (80070003); Provider Error: 0 (0) Error string: The system cannot find the path specified. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error: -2147024893 (80070003); Provider Error: 0 (0) Error string: Cannot open a log file of specified name. The system cannot find the path specified. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4700 DTSRun OnFinish: DTSStep_DTSDataPumpT ask_1 Error: -2147220440 (80040428); Provider Error: 0 (0) Error string: Package failed because Step 'DTSStep_DTSDataPump Task_1' failed. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 700 NULL The job is owned by the SQLService account(Windows account) that has System Admin rights and also is part of the Domain Admin User group. The Domain Admin User group has full rights on the file that the DTS is trying to access. Any help in trying to figure out why the schedule job cannot find the file path would be appreciated. Thanks KR
Post Follow-up to this messageI found the problem was the path in the log file : was using a mapped drive vs a UNC path.
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread