Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Static DTS exports

Status
Not open for further replies.
jazerr

jazerr

Programmer
Dec 13, 2000
152
US
I am running a fairly complicated stored procedure through a static DTS package. I need to be able to click a hyperlink on our website, and have this SP/DTS combo run, then spit out a file for the user to download.

I have already tried hyperlinking the .bas file that MSSQL 2000 creates for me, but my browser tried to download the .bas file. Is there some ASP I can write that will run the VB file? And, if so, how can I export the results for the user to download?

Does this make sense? How can I go about this.
Any help would be fantastic...
 
Status
Not open for further replies.

Similar threads

waubain
  • Locked
  • Question
Convert static PIVOT to dynamic PIVOT on 2 columns
Replies
1
Views
99
waubain
waubain
codrutza
  • Locked
  • Question
Year and Date Imports Exports Conditionally
Replies
5
Views
122
codrutza
codrutza
WMXTeam
  • Locked
  • Question
Convert DTS package to .Net
Replies
0
Views
185
WMXTeam
WMXTeam
smatthews
  • Locked
  • Question
Getting Server Does not Exist Error on SQL 2k DTS package running on SQL 2005
Replies
5
Views
248
smatthews
smatthews
sa0309
  • Locked
  • Question
SQL 2000 DTS transformation
Replies
0
Views
110
sa0309
sa0309

Part and Inventory Search

Sponsor

Back
Top