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 |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2008-11-17 : 11:09:00
|
| Hey is it possible to create a new folder with the week number as the name. So the name would look like WK46. Could i do this from a xactive control in a DTS package? The week number would need to change each week. I then copy my file into into this new folder thats created. |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2008-11-17 : 11:42:26
|
| You could call a bat file with dos commands using DTS to create folders and copy files to it. |
 |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2008-11-17 : 12:08:43
|
| Am not much good at creating batch commands i only know the simple move, coyp, mkdir etc i would not know how to create the folder with the weekend in it for each give week. |
|
|
|
|
|
|
Create a new folder in DTS