Subscribe to this blog
Replacing a SQL Cursor with SSIS
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 the number of times a row needs to be written… Read more
0 comments, 392 reads
Posted in Mike Davis SQL on 22 September 2011
Handling Flat File Headers and Errors in SSIS
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 the flat file has no headers and footers. I am… Read more
0 comments, 731 reads
Posted in Mike Davis SQL on 12 September 2011
Using the SSIS Merge Join
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 must be sorted and there must be a key that… Read more
1 comments, 1,007 reads
Posted in Mike Davis SQL on 6 September 2011
Pragmatic Works Foundation Class Oct 2011
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. We also have more companies interested in looking at the…
0 comments, 230 reads
Posted in Mike Davis SQL on 2 September 2011
Variables and Expressions with Connections in SSIS
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 most likely have Connections, Tasks, Containers, Data Flows and Event… Read more
0 comments, 412 reads
Posted in Mike Davis SQL on 2 September 2011
Convert EBCDIC to ASCII in SSIS
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 ASCII system like a SQL database. This can be accomplished,… Read more
5 comments, 1,910 reads
Posted in Mike Davis SQL on 31 August 2011
SSIS For Each Loop over files with Date in Name
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 with a for each loop, an empty sequence container, a… Read more
3 comments, 2,703 reads
Posted in Mike Davis SQL on 29 August 2011
Using Checksum in SSIS for Delta Loads
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 value of two rows, and the values match, this confirms…
0 comments, 1,154 reads
Posted in Mike Davis SQL on 15 August 2011