SQL Server 2014 and SSDT (AKA BIDS)

Hey folks. This is going to be a short post, just wanted to mention something that may come handy for those who are interested in play with SQL Server 2014. I downloaded SQL Server 2014 a couple of weeks ago and started exploring its new features to see what has changed/improved. After going through very … Continue reading SQL Server 2014 and SSDT (AKA BIDS)

SSIS, Tempdb Database, and SQL Server Log Files

The tempdb system database is a global resource that is available to all users connected to the instance of SQL Server. Tempdb is re-created every time SQL Server is started, which means the system always starts with a clean copy of the database and there is never anything in tempdb that is saved from one … Continue reading SSIS, Tempdb Database, and SQL Server Log Files

Improve your SSIS package’s performance

Hello everyone. I spent almost the whole last week and the first 2 days of this week trying to improve my BI solutions' performance. In my quest on learning the tricks to make my package faster, I came across SSIS Performance Design Patterns video by Matt Masson. A comprehensive discussion indeed, that I'm gonna list … Continue reading Improve your SSIS package’s performance

Spliting records into multiple rows using SSIS Script Component

Hi folks. This is a post in response to Add Interim Rows Depending on Max and Min Values question asked in MSDN SSIS Forum, but it could be applied to any similar situation and problem. HEre I am gonna describe the steps needs to be taken to split the records coming from a data base table … Continue reading Spliting records into multiple rows using SSIS Script Component

Populating Data Warehouse Using SSIS

ETL tools are meant to be used for moving data from a source to a destination. They make life of a data warehouse or BI developer easy by providing easy to use user interfaces and many functionalities to cleanse data before loading into destination. But the situation is not always this easy, especially when moving … Continue reading Populating Data Warehouse Using SSIS

SSIS SQL Server Deployment, File System Deployment, and SSIS Package Store

SSIS packages can be stored in file system, as well as SQL Server. Let’s have a look at each one of these options for storing our SSIS packages. 1- SQL Server: When a package is deployed to SQL Server, it is actually stored in MSDB database. The easiest way to deploy a SSIS package to … Continue reading SSIS SQL Server Deployment, File System Deployment, and SSIS Package Store

Changing a Connection Manager’s Conenction String using C# – SSIS 2008

A SSIS package can be run using C#, or basically any CLR language. The piece of code depicted in the following image calls a package, tries to execute it, and prints any error or exception that occurs dutring execution of the package to output: Simple and easy! Now suppose our package has 2 connection managers: … Continue reading Changing a Connection Manager’s Conenction String using C# – SSIS 2008

SQL Server 2000 stored procedure and SSIS 2008 OLE DB Source

What is the first thing that comes to your mind as a Microsoft BI expert, when you think of a data migration tool? Undoubtedly SSIS! As you all know, SSIS is a great tool for migrating data from legacy systems and databaseas into newer and more robust places and repositories to better serve knowledge and … Continue reading SQL Server 2000 stored procedure and SSIS 2008 OLE DB Source