I need SSIS Package to read flat files per spec provided.
Step 1: SSIS reads excel document formatting attached or another flat file you create from formatting. Creates Tables in Database Specified.
Step 2: Read in flat files provided in a directory and load it into tables created from step 1.
Step 3: SSIS Package 2 based on step 2 in this step option to loop through a directory and load new files, move successfully processed files to specified folder and errors in another. Comprehensive error reporting. Email of errors to list of people, writing of log file to specific directory and log error to specific table.
Propose: what script you would use to read flat file per spec, maybe another c# script to parse file and ssis just does loading into table. Specs specify required and non required files, even if data is not there in flat file still load it , log the issues. In step 1 it basically makes this dynamic so when file specs change, you can reinitialize the load process based on new specs and continue loading files. When creating tables, you can specify Version on the tables, "Record Type xyz ... will be table names and you can assign version to spec v1 , 2 3 ... for future ones.
12 威客就此工作平均出价 $254
Hi, I have 13+ years of experience in data migration and integration using SSIS, Muesoft, etc. I have a similar package which meets your requirements is currently in working with me