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.
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. NULLAny 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. |
 |
|
|
|
|