dts run help

[lendbz]

I have a question,

I have a dts package that connects to a foxpro table (iqvc.dbf) and insert data to it, the package is called "Import_iqvc_inventory"

I generate this line from the dts run utility
"DTSRun /S "(local)" /N "Import_iQVC_Inventory" /G "{59D31918-D2CC-438A-89A5-18E745E07905}" /W "0" /E"

It worked and the package completed when I run the line at a command prompt, but when i test run it in sql anaylzer (I want to put it in my trigger)like this:
"exec master..xp_cmdshell 'DTSRun /S "(local)" /N "Import_iQVC_Inventory" /G "{59D31918-D2CC-438A-89A5-18E745E07905}" /W "0" /E '"

It gave me this error:
DTSRun OnError: DTSStep_DTSExecuteSQLTask_4, Error = -2147217865 (80040E37)
Error string: [Microsoft][ODBC Visual FoxPro Driver]File 'iqvc.dbf' does not exist.
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file:
Help context: 0

Any idea????

thanks,
lenny

 

[mrdenny]

First you don't need the /N and the /G switches. Only one is needed. Use the /N, it's just easier to read.

When you setup the path to the foxpro file did you use the UNC path or a local path to a mapped drive on your machine? You'll need to use the full UNC path to the file "\\server\share\folder\iqvc.dbf". Also make sure that the SQL Servers accout has rights to that folder as well as what ever proxy account your users will be running under when they use xp_cmdshell.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[lendbz]

thanks! i was setting up the odbc data connection to just the mapped drive, after i change it to "\\xerver\..." it work. thanks so much.

lenny

 

[mrdenny]

no problem

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief