SQL Server Integration Services (SSIS) 2012 – Read CSV Files

Ok, let’s talk about SSIS – SQL Server Integration Services.

One of the most common uses of SSIS is to build ETL (Extract, transform, load) processes, to perform data manipulation and store the data on a DW (Data Warehouse).

So, on this first post I’ll show how-to process data and store it on a DW. But we need always a goal, so our goal will be stored Home Banking data.

On the first post I’ll explain how-to build a process that will be the responsible to read our CSV (Comma-Separated Values) files and store the data on our DW (Data Warehouse), as you can see on video below.

[wpdm_file id=13]

I’am updating InPanic to iPhone 5, so I’ll conclude this post after complete the InPanic update.

I’m a lucky guy, because I have access to these magnificent tools. Thank you Microsoft, because your excellent tools and teams.