|
Home > Archive > MS SQL Server DTS > January 2006 > DTS - Parameter - ASP page
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
DTS - Parameter - ASP page
|
|
| BigFellow 2006-01-23, 9:23 am |
| 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
| |
| Darren Green 2006-01-23, 1:23 pm |
| BigFellow wrote:
> 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
>
>
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
|
|
|
|
|