Automate an ETL from a single HTTP file download to SQL Server

$10-30 USD

Completed

Posted

over 8 years ago

$10-30 USD

Paid on delivery

Small training task needed for personal project, this should not take more than 2 hours to complete for a skilled developer. Web File Download and Upload Into SQL Server, Create a short walkthrough video in SSIS or Talend Open Studio showing how to: 1. download a 120mb CSV file from an HTTP source 2. performing a 3 way data split to match up formatting against SQL Server database structure 3. Load the data records into a SQL Server database and send an email notice of any issues 4. Execute a existing Stored Procedure to complete the process

Data Processing

Data Warehousing

Microsoft SQL Server

Project ID: 9447694

About the project

2 proposals

Remote project

Active 8 yrs ago

Looking to make some money?

Email address

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

Awarded to:

@ashupathania

I have 4 + years of experience in MSBI Technology (SQl Server 2008/2012, SSIS, SSRS, and SSAS) Worked with the reputed clients like Microsoft, HCL, and Dicks Sporting Goods etc. Expert in creating Sql queries ,Dynamic T-sql,functions,triggers,indexes,Procedures,cte,temp tables and sub queries . Expert in creating SSIS package, configuration, Deployment and Scheduling and extracting the data from different sources like SharePoint lists, excel files, csv files, Data feed store, MySQL database, sql databases etc. Expert in creating different ssrs reports like drill through, drill down, parameterized, table, matrix,Chart,Line,Stacked columns, Map ,Document type etc. SSRS reports integration with SharePoint and windows applications. Fetching the data from multidimensional cube, tabular cubes with the help of MDX queries and creating SSRS reports. Expert in handling the huge databases (in TB) and performance optimization of the legacy codes.

$25 USD in 1 day