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 |
|
jung1975
Aged Yak Warrior
503 Posts |
 Posted - 2007-06-24 : 17:19:21
|
| I need to move files from one location to another location and rename the file using File System Task in SSIS.. There are curent file and archived files in the folder ( C:\donwload)and i need to grap only current file ( i.e Zipcode062407) and move to C:\staging folder and rename it to currentzipcode.txt how can i grap only current file and move it to the different folder and rename the file using File System Task in SSIS? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-24 : 18:21:41
|
| Can't do that with dos batch file? |
 |
|
|
ekb18c
Starting Member
18 Posts |
Posted - 2007-06-27 : 22:14:54
|
| Not sure how much it will help without pictures but let's try.You will need to create a for loop container and put the file system task in there.You will need to declare a destination and source. Also you will need to create a file task.The file task you will need to click on expressions and select connectionstring.On the connectionstring you will need to set it to the dynamic path of the destination. |
|
|
|
|
|
|
File System Task in SSIS