I have multiple text file in my source folder which I have to import to SQL Server using SSIS and after import all file has to moved to Archive folder. Can any one suggest me the easiest method?
0
votes
1 Answers
1
votes
The first link below provides the basics of using SSIS to archive imported files. The second link provides similar information with additional detail of renaming the archived files with a date/timestamp tag.
Loop through files loading them and archiving them one-by-one
Archive files and add timestamp
Hope this helps.