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 |
|
Jman82
Starting Member
3 Posts |
 Posted - 2005-10-04 : 16:05:12
|
| Situation: I need to create an application that when a button is clicked a report will be generated in Excel using data from a SQL Server 2000 database. Current Status: I have created my application using Vb.net. I have created my tables in my database. Then I used DTS. I basically made a stored procedure and used DTSrun to run a package. The package then calls a view. Based on the results of the view, the package then sends the data selected into a .csv file and places it at a given destination on my server. Then I made a link on the front end that connects to the newly created csv file. It was the only way i could figure it out.SIDE NOTE: I am running SQL 2000 on my desktop and SQL 7 on the server so, I had to use the dtsrunui command from the command promt in order to generate a encrypted sql server 7 formatted DTSRUN string. Thats the only way its compatable, i know that much.Problem: My only problem is that I now have 3 variables that I passed from my vb.net aspx page into my stored procedure and I need to get them into my package. They are ...@database, @school, @grade. I use dtsrunui and create global variables there but it doesnt seem to include them in the string when I generate it. How do I set them/name them there correctly? After that im assuming that will generate the string needed to pass them to the package. Then I need to know how to get them and use them within the package. Then i need to know how to use them in order to query differnet results based on their values. (instead of calling a view, like I am currently doing.) Then send the results to a csv, which I already have set up. Can anyone help???Thanks - John |
|
|
Jman82
Starting Member
3 Posts |
Posted - 2005-10-05 : 15:25:26
|
| I need to know how to send global variables to my package from my stored procedure and the write a query using them inside the transform data task properties. Please help, i need to complete my task very shortly.Or if there is any possible way to use ADO.net with vb to Connect to a package rather then a Stored Proc and send the variables that way. That is fine to.Thanks - John |
 |
|
|
|
|
|
SQL to Excel - Stored P to Pkg Global Variables