Looking for database/stored procedure developer to understand and tranfer data from flat file to database tables.
[url removed, login to view] Server 2008
1. High Level Design, Error handling and data processing Workflow.
2. Data archival strategy.
2. Testing scripts/scenarios
[url removed, login to view] flat file data (Correlation between rows in flatfile)
[url removed, login to view] data from flat file into staging database tables and from staging to reporting tables.
[url removed, login to view] are approx 2-3 stage table and 6-7 reporting tables
[url removed, login to view] error handling and error data reprocessing.
[url removed, login to view] data archival code.
[url removed, login to view] jobs to schedule data loading process.
Được trao cho:
9 freelancer đang chào giá trung bình $245 cho công việc này
Hi, I am Database/SQL Server Expert having more than 6 years hardcore experiance in the above mentioned technologies. Please check your Private message for more details. Regards Nish
Hi, I can build transfer using SSIS,or TSQL script with bcp or dos command(loading and parsing from file data into staging) process will be scheduled to run from bat files or sql agent Alex
Hi, I'm an expert in SQL Server and i can get done your project with good quality and best practices. To solve this problem we can use SSIS technologies and T-SQL.