Tag Archives: SSIS

SSIS Lookup Cache Connection Manager with Excel

Posted on September 26, 2011 by MikeDavisSQL

The lookup transform in SSIS 2008 gives you the ability to join data and eliminate non matching rows. One of the limitations of the lookup is the fact it requires an OLEDB connection. However, with the cache connection manager you … Continue reading →

Posted in SSIS, Syndication | Tagged , , | 1 Comment

Partial Cache Lookup with a Date Range

Posted on September 23, 2011 by MikeDavisSQL

When setting up a lookup in SSIS it is usually just a basic comparison between two key fields like an ID field. What if you want to compare and id and also find the specific date range. Let’s say the … Continue reading →

Posted in SSIS, Syndication | Tagged , | 1 Comment

Replacing a SQL Cursor with SSIS

Posted on September 22, 2011 by MikeDavisSQL

On a forum post recently the questions was asked how to replace a cursor with an SSIS package. This can be done several ways depending on the situation. In this situation there is a number on each row that determines … Continue reading →

Posted in SSIS, Syndication | Tagged , | 4 Comments

White Paper – Troubleshooting SSIS

Posted on September 20, 2011 by MikeDavisSQL

..My SSIS White Paper has been published! Download the White Paper and the Sample Files here. “SSIS is a fantastic Microsoft tool for performing Extract Transform and Loading (ETL) procedures. A challenge in SSIS is identifying a problem once you … Continue reading →

Posted in SSIS | Tagged , , | Leave a comment

SQL Saturday Orlando – Pre Con

Posted on September 7, 2011 by MikeDavisSQL

I’m very proud to announce that Pragmatic Works will be presenting a Business Intelligence Workshop pre-con for SQLSaturday #85 in Orlando on Friday September 23rd! In this session you’ll have not one, not two, not three but FOUR Pragmatic Works … Continue reading →

Posted in SQL Saturday, Training | Tagged , , , , | 2 Comments

Using the SSIS Merge Join

Posted on September 6, 2011 by MikeDavisSQL

The Merge Join Transform in SSIS is a great way to load a Data warehouse quickly and an easy way to join two data sources together. There are a few requirements to join these two data sources. The data sources … Continue reading →

Posted in SSIS, Syndication | Tagged , , | Leave a comment

Variables and Expressions with Connections in SSIS

Posted on September 2, 2011 by MikeDavisSQL

Variables and expressions help make any SSIS package dynamic and flexible. It is always a best practice to use variables in a package, especially when the information is used more than once in the package. In any package you will … Continue reading →

Posted in SSIS, Syndication | Tagged , , | Leave a comment

Convert EBCDIC to ASCII in SSIS

Posted on August 31, 2011 by MikeDavisSQL

    Converting EBCDIC to ASCII in SSIS 2008 can seem like a daunting task. There is a lot of manual work involved in creating a data flow to move data from an EBCDIC system like AS400 or DB2, to an … Continue reading →

Posted in SSIS, Syndication | Tagged , , | 10 Comments

SSIS For Each Loop over files with Date in Name

Posted on August 29, 2011 by MikeDavisSQL

A common request I have received over the years is to move or copy files from one directory to another based on the file name.  This can be accomplished in SSIS without using any script task. You can do this … Continue reading →

Posted in SSIS, Syndication | Tagged | 22 Comments

Using Checksum in SSIS for Delta Loads

Posted on August 15, 2011 by MikeDavisSQL

The checksum function in SQL is a great way to compare two rows to see if the data matches. The checksum command returns a number that represents the value of the data in the row. When you compare the checksum … Continue reading →

Posted in SSIS, Syndication | Tagged | 7 Comments