Loading zip files in the database
Budget: $250 – $750 USD
I need help in SSIS.
Here is my task detail:
I am working on a SSIS package that will load the input files from the client in the database. The files come in 'zip" with a timestamp and a sequence number in the end.
Here is how the incoming files will look like in the input folder:
abcYYYYMMDDHHMISS-001.zip
abcYYYYMMDDHHMISS-002.zip
The SSIS package when runs it should get all the files which have arrived in last 24 hrs. It should get the file with "001" sequence first then get the "002". Then unzip the file load the text flat files to a sql server table. Then delete all text files and Archive the zip file in another folder.
Here is my task detail:
I am working on a SSIS package that will load the input files from the client in the database. The files come in 'zip" with a timestamp and a sequence number in the end.
Here is how the incoming files will look like in the input folder:
abcYYYYMMDDHHMISS-001.zip
abcYYYYMMDDHHMISS-002.zip
The SSIS package when runs it should get all the files which have arrived in last 24 hrs. It should get the file with "001" sequence first then get the "002". Then unzip the file load the text flat files to a sql server table. Then delete all text files and Archive the zip file in another folder.