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 |
|
ChrisHorsley
Starting Member
7 Posts |
 Posted - 2004-09-09 : 09:39:13
|
| I set up a DTS package using the export wizard to perform a multitable query that I am then exporting to Excel. The query is beingsorted by the EmployeeID. . I would like to find a way to replace thereference to a specific EmployeeID (inside of the query) with a globalvariable and automatically export using the EmployeeID(globalvariable) as the name of the Excel file.I set up a global variable named gEID and am populating the globalvariable with a query that extracts just the EmployeeIDs from theemployees table. Can someone please suggest a way to loop througheach EmployeeID as each query is run and Excel filed is exported?Have seen several articles concerning looping but they usually appliedto importing data not exporting to individual files. |
|
|
|
|
|
Export queries to individual Excel files