0
votes

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?

1
This is one of the core functionalists of SSIS. What research did you do? What have you tried? - Brad
Step 1) Import data, Step 2) Move the files. What's the problem here? - James Z
Research the Foreach Loop Container and the File System Task. - tonyd

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.