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.

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.

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.