Suoritettu

SSIS Package for CSV processing

I am looking for an expert in the database sector, to support R&D project. I have a large CSV File and we look to develop an SSIS package for CSV processing.

1. Link to the data set: [login to view URL]

2. Un-zipped CSV file weights 2.2 GB.

What I'm looking for is:

1. Setup of the solution on my PC, that will enable management of the data set.

2. Training on how to filter, and export range of the data for the filter into formats such as excel.

Taidot: SSIS (SQL Server Integration Services), Microsoft SQL Server

Näytä lisää: plotting csv files excel, processing excel sheet javascript, graph csv files excel, how to load multiple comma delimited files to sql server table in ssis package, how to create csv file dynamically in ssis, import data from flat file to sql server using ssis, how to import csv file in ssis package, ssis import multiple csv files, ssis export to csv file, how to create multiple flat files dynamically in ssis, ssis create flat file dynamically, dhtml csv processing, ftp task ssis package, format csv fields excel, csv import excel, signal processing excel, word processing excel service, csv calendar excel, combined csv files excel, ssis package extract sql data text file

Tietoa työnantajasta:
( 0 arvostelua ) Salford, United Kingdom

Projektin tunnus: #27417237

Myönnetty käyttäjälle:

marasinghe82

Dear Sir, Please share remote session with me I can complete this project within one hour I am a Tech-lead on Business Intelligence with more than 14 years of experience on MS SQL Server (SSIS SSAS SSRS) , Power BI. Lisää

£20 GBP 1 päivässä
(7 Arvostelua)
4.4

4 freelancers are bidding on average £49 for this job

sumon355

Hello, I downloaded the file and checked it. I see it has 55 columns and almost 5 millions of lines. I can import this file to a database table and provide you the mssql database backup. I am not fully clear on what el Lisää

£50 GBP 1 päivässä
(143 arvostelua)
7.5
SqlDevelopment

I can develop SSIS package for import csv file. But need to do some experiment first to check how will SSIS work with so big file. Training regarding to filtering and data export will be provided also. I have enough ex Lisää

£80 GBP 2 päivässä
(16 arvostelua)
3.7
aldrinmachado

Hey there, Your requirement is pretty straight forward and can be implemented easily. But the issue here is size of csv which as per you is in size range of GB. Your personal PC has memory limitation(RAM) which would c Lisää

£45 GBP 5 päivässä
(0 arvostelua)
0.0