dbTalk Databases Forums  

DTS schedule error

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS schedule error in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
mark
 
Posts: n/a

Default DTS schedule error - 01-21-2005 , 08:57 AM






I've got the problem. I created DTS package that copy data from SQL Server to
the text file.
The DTS successfully execute from 'Data Transformation Services', but when
DTS schedule to run in SQL Server Agent it gives the error.

DTSRun: Loading... DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnError: DTSStep_DTSDataPumpTask_1,
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: DTSStep_DTSDataPumpTask_1 DTSRun: Package execution complete.
Process Exit Code 1. The step failed.

Is anybody can help, please.

thanks.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.