SQL Server 2005 SSIS Package - Import Files and Update tables
$100-200 USD
착불
Developer will need to create a SQL Server 2005 database with three tables.
One table for tracking the files to import and stats. The other are? staging table to hold the file import and a target table for all the unique data with updates.
A SSIS 2005 package will need to be created. The package will monitor a source folder for new files (can be scheduled once daily). If a new file is found, the file details are stored and then the file is imported into a staging table. The data in the staging data is compared to the target data to see which rows are new data and which ones are updates. Then the target data gets the new data items inserted and then gets rows updated. The unique identified in the staging and target table is the NDC codel. Whicle the imports has a flag stating the row type is, a field to field comparison should still be done.
A simple layout of the workflow is attached, plus the layout for the file and three sample files.
Please note if you have no experience with SQL Server 2005 & SSIS, please do not bid.
## Deliverables
Deliverables
1. Backup of the SQL Server Database
2. SSIS Package
프로젝트 ID: #3272223