SQLServer '05 SSIS pckg that reads .csv files from directory

We need an SQL Server 2005 SSIS package that reads all .csv files from a (user-defined) directory. The package will then write the contents of all of those files, as well as the file name (minus the file extension) and bottom-level file directory, to a SQL Server database table. All the .csv files will only have two columns (with headers) and therefore the database table will have four columns: FileDirectory, FileName, Column1Value, Column2Value. The directory to be scanned should be a user-configurable @ variable in the .dtsx file.

For example, there are two files in D:\testserver\sampledata\tempdir\ that are named [url removed, login to view] and testfile2.csv. These files have the following data:

[url removed, login to view]:

Column1, Column2

Truck, Big

Red, Ball

Games, Fun

[url removed, login to view]:

Column1, Column2

Car, Small

Blue, Ocean

Work, Hard

The database table would be populated like this:

FileDirectory FileName Column1 Column2

tempdir Testfile1 Truck Big

tempdir Testfile1 Red Ball

tempdir Testfile1 Games Fun

tempdir Testfile2 Car Small

tempdir Testfile2 Blue Ocean

tempdir Testfile2 Work Hard

Kemahiran: SQL

Lihat lagi: sqlserver ssis pckg reads csv files directory, SSIS SQL, Sql ssis, sql server ssis, sql server 2012 ssis, blue car, reads, table csv, csv table, sql file csv, car data file, sql fun, write work package, sql data csv, data scanned table, games car, database car sql, sql car database, sqlserver database, ssis package, car database need, data fun work, database csv car, red car, file directory

Tentang Majikan:
( 1 ulasan ) Glen Allen, United States

ID Projek: #1528325

Dianugerahkan kepada:


We've done it already. The package is ready to be delivered. Please see PM for details & screenshots. Thanks!

$100 USD dalam 0 hari
(6 Ulasan)

8 pekerja bebas membida secara purata $138 untuk pekerjaan ini


Please see PMB.

$200 USD dalam sehari
(9 Ulasan)

Hi, I am an I.T. professional with over 20 years of experience, with the last 10 years specialising in databases and business intelligence systems, including report design, ETL processes (including SSIS) and software d Lagi

$125 USD dalam 3 hari
(1 Ulasan)

Hi, I am a seasoned SQL Server geek and quite confident of delivering according to your expectations in the required timeline.

$130 USD dalam 2 hari
(0 Ulasan)

Hi, Alvicreatives has been long into web application development & designing and development business. The last 5 years, we are working on web based ASP.net / C#, Sqlserver 2005/2008, Ajax, CSS, Flash,PHP,MySql,Wor Lagi

$200 USD dalam 15 hari
(0 Ulasan)

I am a IT professional and I have experience about it, specialising in databases and business intelligence systems, SSIS,SSAS,SSRS and software development. I have used SSIS in the past

$150 USD dalam sehari
(0 Ulasan)

Since I have been involved in such tasks but of greater magnitude, I am pretty sure that it would be quiet easy for me

$100 USD dalam sehari
(0 Ulasan)

We are experts on SSIS projects, more thatn 5 years of experience.

$100 USD dalam 2 hari
(0 Ulasan)