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 |
|
gvgonong
Starting Member
6 Posts |
 Posted - 2008-08-15 : 09:26:51
|
| I have a text files that are coming from SAP and it generates in a daily basis (i.e. filename_08082008.txt, and etc.)in the same folder. My question is how can i move each text file without renaming it to the Archive folder after i load it in the DB?Thanks in Advance. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-08-15 : 09:31:59
|
| Have a look at the File System Task in SSIS. There is an option to move files.WebfredToo Old to Rock 'n' Roll, Too Young to Die |
 |
|
|
gvgonong
Starting Member
6 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-16 : 00:59:47
|
| I think what you need to use is For Each Loop container. There's an option called for each file enumerator which searches for files in a folder and transfer them. more details in below linkhttp://www.sqlis.com/55.aspx |
|
|
|
gvgonong
Starting Member
6 Posts |
Posted - 2008-08-16 : 07:59:37
|
| Thank you all,Although the link that you all provide gave an idea. I some how manage to move all of my files to the other destination by using the For Each Loop container, File System Task and a couple of file connections. Thanks. |
|
|
|
|
|
|
Moving text file using SSIS