Hi there,
I would like to get the data from DTS package onto Excel
sheet in a dynamic manner. For example the web user would
enter the required fields from ASP page to the package
and the package should deliver the requested columns onto
the Excel sheet. In a table I have 4 columns such as
Col1, Col2, Col3, Col4 but the user wants only Col1 and
Col2 to be transformed into Excel sheet. How do I do it?
If some one can help in this that will really help
Thanking you in advance.

John
I would be interested in also how to handle the DTS calls
in Web interface (VBScript example would be fine). I am
just a novice to this DTS programming if someone can
direct where I can get information that will be great.