Author Archives: MikeDavisSQL

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

BI Xpress Infomercial

Posted on September 22, 2011 by MikeDavisSQL

Check out this cool Infomercial Pragmatic Works made about BI xPress. http://pragmaticworks.com/landing/bixpressinfomercial.aspx

Posted in Pragmatic Works | Leave a comment

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

Handling Flat File Headers and Errors in SSIS

Posted on September 12, 2011 by MikeDavisSQL

Using SSIS to load a flat file into a database is a common use of the tool. This works great in SSIS and is very fast due to the dataflow doing batch updates. This is easy to set up when … Continue reading →

Posted in SSIS, Syndication | 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

Pragmatic Works Foundation Class Oct 2011

Posted on September 2, 2011 by MikeDavisSQL

I am super excited to announce that there is a strong demand for the Foundation Training to be held more frequently.  Our last one was held in August and several people were hired for Jr. DBA and Report Writing opportunities.  … Continue reading →

Posted in Foundation, Training | 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