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 |
|
NosheenA
Starting Member
1 Post |
 Posted - 2005-06-27 : 10:42:55
|
| I am running a shceduled job which runs a stored procedure and DTS to a csv file. The stored procedure populates a temp table. Then the DTS export the contents of the temp table to a csv file. I need to export to a new file name everytime. The filename having datetime, for uniqmenss and also history record.How can i achieve this? This is urgent!Thank you |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2005-06-27 : 11:03:00
|
| Use an ActiveX script to set the source property of the text connection to something involving the current date. If you are running the stored proc each time, then I don't see the point in populating a temp table. Just call the stored proc in the datapump task.Mark |
 |
|
|
|
|
|
DTS out to a file name with julian date/time