Hi ,

I have an existing MI System that uses a third party command line
application to retrieve and store data in text files , i want to automate
this using DTS . The third party command line applications expects one param
at a time , is it possible to design the system using DTS , in which i store
all the parameters in database table and then pass this to ActiveX Script
Task to process. Lets say i have

CorpA
CorpB
CorpC
CorpD

I retrieve above using SQL Task , is it possible to pass these parameters to
next task that is ActiveX Script.

Please let me know .

Awaiting expert opinions.

Cheers
Vishal

You would use an ExecuteProcess task right and use this article.

How to loop through a global variable Rowset
(http://www.sqldts.com/default.aspx?298)

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Vishal Gandhi" <Vishal Gandhi (AT) discussions (DOT) microsoft.com> wrote

Thanks Adam
Vishal Gandhi wrote: