Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Running DTS Package on remote server from foxpro

Status
Not open for further replies.

kenndot

Programmer
May 15, 2001
316
US
Hi all, I have this in the fox section, too, didn't know if anyone here could help...

RUN DTSRun /S "DWPROCESS" /N "SiteCount_1_LoadTextFiles" /G "{00B299BE-E99A-4CA2-AC5D-2254B3D5F0DB}" /W "-1" /U dts_test /P test

there is a param here that foxpro doesn't like

we tried it like that... and

RUN DTSRun /S "DWPROCESS" /N "SiteCount_1_LoadTextFiles" /G "{00B299BE-E99A-4CA2-AC5D-2254B3D5F0DB}" /W "-1" /E

this doesn't generate any errors, it simply doesn't run anything

i can't think of what is missing, can you help me?

i know I can create a dts object, i'm doing that now, but i would really like to know if there's something else I can do to run this using the run command since it's so much easier.
 
Keep in mind that you could always run the DTSRUN command from a DOS Prompt just to make sure that the information is valid. Keep in mind that the Package GUID String changes when modifications are made to your package. It is not necessary if you are providing /N (Package Name), so I would drop the /G parameter all together and see if that helps.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top