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 |
|
Gopher
Yak Posting Veteran
83 Posts |
 Posted - 2006-06-09 : 10:14:44
|
| Hi AllI have a dts package which generates data based on tables and the idea is that this data is output to an Excel file. However the data is based on locations so each location will have a seperate excel file. So I want to end up will a folder with excel files all named with their location.Can anybody help?CheersGopher |
|
|
sanjnep
Posting Yak Master
191 Posts |
Posted - 2006-06-09 : 10:45:56
|
| Hi Gopher,I think you need to write some ActiveX Script on DTS package to do your task. You may find something useful over this linkhttp://www.sqldts.com/Thanks Sanjeev ShresthaOH |
 |
|
|
Gopher
Yak Posting Veteran
83 Posts |
Posted - 2006-06-12 : 05:28:16
|
| Thanks sanjnep however the site errors everytime. Do you know of anywhere else? |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2006-07-06 : 11:46:48
|
| That's doable, see me on msn. You're looking for a dts that loops thru a recordset.---Thanks!Igor. |
|
|
|
|
|
|
Generating multiple Excel files using DTS?