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 |
|
lemondash
Posting Yak Master
159 Posts |
 Posted - 2007-01-11 : 06:54:27
|
| Guys/GirlsNeed a little help with something.Have a dts job that exports data to excel spreadsheet every hour of the day. But what i want it to do is name the spread like this every time it runs .i.e C\data\exportdata_"time and date".xlsRegards Lee |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-01-12 : 06:34:58
|
| You can do this within an ActiveX Script task. If you're not comfortable with setting the Excel connection's properties within the task via the DTS object model, it might be easier for you to set a global variable with the path string, and then use a dynamic properties task to set update the relevant connection property. You'll almost certainly find example code to do this on [url]www.sqldts.com[/url]Mark |
 |
|
|
|
|
|
dts job