Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-26 : 23:09:40
|
Don writes "Here is the situation:
We are building a website using ASP where users login and run queries (stored procs) to create reports. The stored proc execute DTS package to create the report (a delimited file) for their use.
I would like to use the user login information to create a specific report for the user by passing in params to stored proc and then to DTS package. For example, if Smith login, I want to create Smith-02-26-2001.txt file and create it in the folder /UserReports/Smith.
Is this possible? If so, please help and show me.
Thanks,
Don
SQL Server 7.0(SP2) on Windows NT(SP5).
Planning to move to SQL 2000 on Windows 2000 Server next month. If possible in SQL Server 2000 only, please let me know." |
|
|
|
|
|
Passing params to DTS packages from ASP through Stored Proc