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.