Lengkap

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.

Kemahiran: SSIS (SQL Server Integration Services), Pelayan Microsoft SQL

Lihat lagi: 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

Tentang Majikan:
( 0 ulasan ) Salford, United Kingdom

ID Projek: #27417237

Dianugerahkan kepada:

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. Lagi

£20 GBP dalam sehari
(7 Ulasan)
4.4

4 pekerja bebas membida secara purata £49 untuk pekerjaan ini

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 Lagi

£50 GBP dalam sehari
(143 Ulasan)
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 Lagi

£80 GBP dalam 2 hari
(16 Ulasan)
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 Lagi

£45 GBP dalam 5 hari
(0 Ulasan)
0.0