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 |
|
Shamee_1321
Starting Member
15 Posts |
 Posted - 2008-04-17 : 05:51:59
|
| Anyone knows how to give the name of a flat file specifying today's week number??filename_wwfor today it should be filename_16 (since week number is 16) |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-04-17 : 07:17:27
|
| "filename_" + DatePart(DateInterval.WeekOfYear, Today) |
 |
|
|
|
|
|
Dynamic Name for Flat file destination - WEEK NO