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 |
|
dturner
Starting Member
24 Posts |
 Posted - 2006-10-25 : 13:25:11
|
| Wanting to use File System Task in SSIS to move files from one location to another for archiving. I can't seem to figure out how to use a wild card for the file name. It seems that I must specify the actual file name which is a problem because only the first 4 letters in the file name remain a constant. Does anyone know how to use a wild card or a way to work this in?The world has more information to offer than I can hold in my head |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-10-27 : 09:15:06
|
| You can probably do it using a for each file task to get the file name.This shows how to use the for each loop - should be easy to use the file system task instaed of execute packagehttp://www.simple-talk.com/sql/sql-server-2005/executing-ssis-packages-/But why not just use a o/s move command.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
File System Task in SSIS