Scheduling to run a DTS package problem

Question

Viewing 3 posts - 1 through 4 (of 4 total)

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

Perry Harts Ten Centuries Points: 1271 More actions · Answer 1

When you schedule a DTS from the DTS it will create a job. Does that job fail also?

Karthika Raman SSCrazy Points: 2520 More actions · Answer 2

I did not go that route. Anyway I have since solved this problem- The logfile path was set to a mapped drive vs a UNC, and changing fixed it.

Thanks for you input

KR

ofer magen-195663 Newbie Points: 7 More actions · Answer 3

i have the exact oppsite problem

i have a package with cmd execute that executes a batch file from

another server through a mapdrive like that:

p:\bat_name.bat

the job fails and i get this error in the package error handaling:

"....

Step Error Source: Microsoft Data Transformation Services (DTS) Package

Step Error Description:The system cannot find the path specified.

(Microsoft Data Transformation Services (DTS) Package (80070003): The system cannot find the path specified.

)

Step Error code: 80070003

Step Error Help File:sqldts80.hlp

Step Error Help Context ID:1100

......"

when i chagne the mapdrive to unc like that :

the job works fine

please help