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 freelancer đang chào giá trung bình $254 cho công việc này
Dear Sir, I fan complete this within one day time pls let me know if you ok to offer this job to me. then I can start work on this Best Regards, Jinesh
I am good in powershell, mssql, SSIS along with flat and excel file handling stuff, please let me know if you are good to award this project to me and max budget
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