Find Jobs
Hire Freelancers

SSIS Package To read flat file per Spec

$10-30 USD

Closed
Posted over 4 years ago

$10-30 USD

Paid on delivery
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.
Project ID: 21135119

About the project

12 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
12 freelancers are bidding on average $254 USD for this job
User Avatar
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
$111 USD in 1 day
5.0 (69 reviews)
5.7
5.7
User Avatar
Hi, My name is Ali and I can work with immediate availability. Let's have quick discussion so I can work on it.
$70 USD in 11 days
5.0 (30 reviews)
4.7
4.7
User Avatar
Hi i am expertise in ssis and etl py ping me if u art interesting and also need few inputs let’s discuss
$455 USD in 5 days
4.9 (18 reviews)
4.4
4.4
User Avatar
Proposal - You can expect any kind of work on SSIS and SQL Server from me. But before to talk with me pls check my bidding amount. Let me know if you want to discuss further. I am a database / Business Intelligence / solution architect. I have more than 14 years of experience in various technologies as mentioned below: Database/Datawarehouse - SQL Server, Oracle, MySQL -- Proficiency (P4) BI - Microsoft MSBI and Informatica ETL -- Proficiency (P4) Dotnet - C# (core), ASP.Net (core), MVC, Javascripting etc... -- Proficiency (P3) Cloud - Azure (Paas and IaaS) -- -- Proficiency (P1) My Technical background • Having good amount of practical exposure on AngularJS, MVC, Javascript, ASP.Net with C#, VB.Net language and executed multiple projects independently. • Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models • Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas • Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;
$150 USD in 3 days
5.0 (13 reviews)
4.2
4.2
User Avatar
Hi, I'm a database architect and programmer having more than 15 years of experience with different types of domains like telecom, payroll, banking, insurance, crm, ecommerce etc with high data volumes and I'm experienced with oracle and ms-sql and also experienced with ssis for data migration and data cleansing. Please contact me for more information. Also be informed that I have done similar application for Mexican client. Cheers!
$500 USD in 10 days
4.5 (4 reviews)
3.2
3.2
User Avatar
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
$30 USD in 10 days
5.0 (1 review)
1.5
1.5
User Avatar
While working in B2Bsoft company I have made a lot of complex ETL engines based on SSIS with different data sources. Described task is difficult and very complex. But i am completely experienced to resolve it. But bid amount i defined is not complete amount. Because my account does not allow higher money values due to it beginners state. Complete cost will be about 3000$ and about two weeks for development. This is gross estimate.
$1,350 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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
$50 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can do your project on time and within budget
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Northridge, United States
4.9
48
Payment method verified
Member since Nov 30, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.