Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Error when calling DTS in store procedure

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-01-31 : 09:04:07
Confused writes "I have a DTS Package that runs fine when I execute it from Enterprise manager but when I call in my Sproc I get an error.

This is how I'm calling the DTS in the SP:

EXEC master..xp_cmdshell 'DTSRUN /N dtsCertegyImportFileCreate /E /S GSPDB'



Here is the error I get back after calling the SP in Query analyzer:


DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: Copy Data from Results to C:\Documents and Settings\Dand\Desktop\Electrum\certegy.dta Step
DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1
DTSRun OnError: Copy Data from Results to C:\Documents and Settings\Dand\Desktop\Electrum\certegy.dta Step, 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: Copy Data from Results to C:\Documents and Settings\Dand\Desktop\Electrum\certegy.dta Step
DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1
DTSRun: Package execution complete.
NULL



Any ideas what I'm doing wrong?"

nr
SQLTeam MVY

12543 Posts

Posted - 2006-01-31 : 10:22:10
Suspect t's because when you open it from the sp it runs on the server rather than your workstation. The file paths need to be relative to the server.
i.e. that c:\ will be on the server not your m/c.

(dts is a client app).

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -