Hi,
I would like to be able to run a DTS from an ASP page (not an ASPX)
giving the DTS package parameters on the fly.
My goal is to be able to give a table name and to retrieve the table
content locally in a text file.
Thanks,
BigFellow

BigFellow wrote:
Execute a package from Active Server Pages (ASP)
(http://www.sqldts.com/default.aspx?207,1)

Setting parameters is the same as the VB syntax shown here-

Execute a package from Visual Basic (VB)
(http://www.sqldts.com/default.aspx?208,3)

You will need to add some additional code to handle the file and passing
it back to the user. The package will run on the web server, so you will
write the file there, then read and write to the user, or redirect to
the file if it is available within the web file structure.


--
Darren
http://www.sqldts.com
http://www.sqlis.com