One of my colleges wrote me this today. Not having added DTS to VFP, I could not answer his question with certainty.
I will make sure he gets onboard with UT.

-----Original Message-----
From: Mark Dowlearn [mailto:mardow@pacbell.net]
Sent: Wednesday, August 15, 2001 8:14 AM
To: Mark W. Holmes
Subject: DTS question

Hello, Mark -

Since you have been involved with DTS, may I trouble you for some advice on some DTS-related matters? (I guess that's what you get for being the SQL/DTS guru <s>).

In the application I've been working on, I am triggering some DTS packages (SQL2000/Package2) from some of my wizard screens (batch import is the primary function).

I'm now at the point of being ready to test a distribution copy of my app on a client machine, using VFP7 and the VFP version of InstallShield Express that comes with it to build the setup disk.

From what I can figure out, I need to distribute the dts.msm merge module with my app (since the client machine does not already have DTS capability installed). Can you confirm that this is true, and if there are any other DTS-related files that I must include and register on the client machine? It's my understanding that the original dts.msm was buggy and that I can get the updated dts.msm file from the SQL Server Service Pack 1 disc....

Thanks in advance ... see you tomorrow night.

Yours,

Mark Dowlearn