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 |
|
GenerationWithoutName
Starting Member
26 Posts |
 Posted - 2003-02-25 : 02:55:07
|
| Dear All,I can Export my data from SQL 2000 to text file via DTS,but i want a filename result no static filename, i want itdynamically ex: by date of export...how can i do that??? |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-02-25 : 06:09:59
|
| You can use the Dynamic Properties Task of DTS. Take a look at it.Another option is to use BCP instead. You can find more information in BOL. |
 |
|
|
|
|
|
SQL to textfile