In order to provide variable information like this to a DTS package, you will probably have to call a server-side application. The app will load the DTS (via DTS objects), pass the values to global variables define in the package, then run it. Unfortunately I don't have any quick examples to show you how this works (but I might in a couple days).
ASP can pass the variables to the app and kick it off. Either VFP or VB can handle the calls to the DTS objects.
Hope that helps. I'll try to get an example worked up unless someone else has one working.
Dan LeClair
www.cyberwombat.comSET RANT ON - The Wombat BlogLife isn’t a morality contest and purity makes a poor shield. - J. Peter MulhernDisclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.
