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.

Навыки: SSIS (SQL Server Integration Services), SQL-сервер Microsoft

Показать больше: 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

О работодателе:
( 0 отзыв(-а, -ов) ) Salford, United Kingdom

ID проекта: #27417237



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. Больше

£20 GBP за 1 день
(7 отзывов(-а))

4 фрилансеров(-а) готовы выполнить эту работу в среднем за £49


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 Больше

£50 GBP за 1 день
(143 отзывов(-а))

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 Больше

£80 GBP за 2 дней(-я)
(16 отзывов(-а))

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 Больше

£45 GBP за 5 дней(-я)
(0 отзывов(-а))