Find Jobs
Hire Freelancers

SSIS Package to Read Flat Files and Format them

$30-250 USD

Closed
Posted about 5 years ago

$30-250 USD

Paid on delivery
There are 2 types of flat files , they are like EDI files but not exactly. So if you have experience with EDI you should be able to figure this out quickly. I need package that loops through a directory , picks up flat files with specific extension (in this case .dat needs to be configurable in package) then processes it by reading it and loading it into a table. There are 2 file specifications attached when you get sample files some fields might be blank which is not an issues. Biggest work here is to get the file specifications programmed in c# or another scripting language that will read the file restructure it into a form that you can import into a table. Attached are only file specs review them carefully i will provide sample files once you have understanding of work involved. Have very limited budget for this. I will also need a ssis package that will export to same file format v5 or v6 if needed from the table you created and imported data into.
Project ID: 19450343

About the project

18 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
18 freelancers are bidding on average $168 USD for this job
User Avatar
Hi I am a Dedicated Senior .Net Developer and Database Administrator with 20 years of experience in Web/ Windows and Android Developments, Administration, Project Management System analysis, and Database Developments. Delivering quality solutions to business problems within scope, budget and tight schedules whilst meeting strict specifications both functional (for users ) and technical (for Developers) , from project planning, estimating to delivery. Please See my profile and the Reviews I would like to discuss the project in details with you for a better understanding of the requirements. SKILLS AND ABILITIES • Web | Windows Developments | API | Web Services| • .NET | C# | Vb.Net | ASP.Net | VBA | MACROS • SQL Server | MY SQL | EXCEL | MS ACCESS | PostgreSQL |Sybase | SSIS • MVC| | Web Forms | Win Forms| Java scripts | JQuery | Json • HTML | PHP | CSS | Bootstrap |Graphic Design • IIS | Windows Server | • Crystal Reports | iText Sharp • XML | XLT | CSV • Payment Gateway Integration • Android Developments APPLICATION DEVELOPMENTS • Web Applications • Automated email Tools • Document scanning tools • Imail API integration • Sage / XERO Accounting Integration tool • Web Services API's • Google Map integration • E-POS System • General Ledger System • Payroll & Time Attendance System • Help Desk System • Cost Management System • Fixed Asset System • Budget Control System
$197 USD in 7 days
5.0 (33 reviews)
6.0
6.0
User Avatar
Hi, I am a Full stack developer in Microsoft technologies. My area of expertise is web application development (asp.Net web forms, MVC, classic ASP), web services (SOAP & RESTFul), MySql & Sql Server as back end (through stored procedures). I have 7 years of experience as a full time software developer. Kindly contact me, lets discuss your requirements.
$250 USD in 7 days
4.9 (22 reviews)
5.4
5.4
User Avatar
Hi there My name is carlos and i am a especialist in .net and sql server I have been working in software development for the last 20 years Regards
$155 USD in 3 days
4.8 (33 reviews)
5.3
5.3
User Avatar
Hi MBNS1, We have read your project details and we are very much interested to work with you Best regards, Michael
$185 USD in 3 days
5.0 (10 reviews)
5.1
5.1
User Avatar
Proposal - SSIS is the best tool to fulfill such requirements. I am ready to take this and will be able to give you full quality work. I have more than 10 years of experience only on this tool. Let me know if you are ok 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 BI - Microsoft MSBI and Informatica ETL Dotnet - C# (core), ASP.Net (core), MVC, Javascripting etc... Cloud - Azure (Paas and IaaS) My Technical background • A goal-oriented professional with more than 14 years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain • 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;
$188 USD in 3 days
5.0 (30 reviews)
5.0
5.0
User Avatar
SSIS, TSQL I have many experiences. I can complete your project successfully. I'm powerful database manager and data mining expert.. Well designed SQL will make your project useful and powerful. I can make nice SQL for your project. I'm software engineer,fullstack web developer, java, C&C++ perfecter. I'm sure that you may feel nice from me. Thank you.
$150 USD in 10 days
4.9 (13 reviews)
4.5
4.5
User Avatar
hi I am expertise in ssis and scripting please let me know few more information to work on this and finish. if you are interested ping me .
$180 USD in 3 days
4.9 (16 reviews)
4.4
4.4
User Avatar
Microsoft Certified BI Datawarehouse Developer looking forward to hear back from you to discuss the opportunity in detail. please ping Thanks
$111 USD in 2 days
5.0 (3 reviews)
2.0
2.0
User Avatar
 Over 7 years of IT experience in various domains as Developer that includes Database Design and Development, Microsoft BI Solutions, ETL Development, Data warehouse Implementation, Report Development using SQL Server 2014/2012/2008R2/2008, SSAS, SSIS, SSRS and TSQL.  Over 2yrs of Canadian Experience in working with Client team and Vendors.  Extensive experience in Database development for OLAP Systems (SSAS, SSIS, SSRS) using SQL Server 2016/2014/2012/2008R2/2008.  Extensive experience in Analysis services development (both star and snow flake schemas) of multi-dimensional models and tabular models using SQL Server 2014/2012/2008R2/2008.  Extensive ETL experience using SSIS for Data Extractions, Transformations and Loads.  Extensive experience in providing Enterprise Reporting solutions using SSRS 2014/2012/2008R2/2008.
$133 USD in 3 days
5.0 (2 reviews)
0.6
0.6
User Avatar
Certified MSBI -Data Warehousing expert, active on Power BI and working in BI tools from last 9 years. Have already worked on the script as source excel files to various destinations. Relevant Skills and Experience MSBI, SSIS, ETL, DW, .NET, Power BI, Reporting
$250 USD in 7 days
5.0 (2 reviews)
0.5
0.5
User Avatar
I need to see an example of the dat file but my proposal will be a job you double click on it and it transfers this to a sql or mysql database. The settings can be set in a config file Relevant Skills and Experience I have been doing such manipulations of files and data and creating such automations for years, not a big job as such
$144 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I've experience in working with various EDI projects which includes loading data from excel, Flat files(Notepad), .csv files, XML files etc into MS SQL tables. In order to accomplish the task have created various SSIS packages and customized the flow using c# development where required.
$155 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
HELLO I CAN START RIGHT NOW - I AM EXPERT IN .NET C# Programming and I BET YOU CANNOT FIND BETTER FREELANCER THAN ME ... pLEASE MESSEGE ME AND LETS DISCUSS THE THINGS THANKS
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 7 years of experience with SQL server SSIS and c#. I had working experience with EDI file formats and was handled similar requirement in my earlier project. if you give me this project, I can deliver with good quality
$166 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am having 14+ years of working experience in developing the advanced database warehousing solutions using SQL Server and various ETL tools. I am interested into this job and I am sure we would have a great engagement relationship. Let me know if you need more information. Looking forward to working with you. Thanks, Santosh Payasi
$150 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.