dts error

Question

dts error

Sujith-222781

Newbie

Points: 9
More actions
April 6, 2005 at 12:36 pm

#165064

Hi all
While iam exectting a dts pacakage by scheduling ..ie in SQL server
fall in failure even after package executed
while i go through the out put file in job
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: 1100

Error Detail Records:

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: 1100

DTSRun OnFinish: DTSStep_DTSDataPumpTask_2
DTSRun: Package execution complete.

Any body pls help me to solve this
Advance thanks
Sujith

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

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

David.Poole SSC Guru Points: 76001 More actions · Answer 1

In your transformations there is an "options" tab. There is an exception file tab. If you have a file name filled in either remove it or make sure that the SQLSERVERAGENT service login account has rights to where the file is being written.

LinkedIn Profile

augustin Carnu-215787 SSC Enthusiast Points: 192 More actions · Answer 2

You must configure a path and a file for the system to write the error log

use format: \\server\c$\folder\filename or whatever drive you have...

Cheers,

Augustin Carnu

rrwahls Grasshopper Points: 12 More actions · Answer 3

Thanks for the solutions. I tackled this problem two years ago and I dealt with the package level error file when re-creating a DTS, but I forgot about the default transformation level one.

RW