Monthly Archives: June 2008

Continuing a Loop After an Error

A common question on the SSIS forums is how to continue a loop after an error occurs. For example, you might have a For Each Loop container that iterates through a set of files in a folder. If one file … Continue reading

Posted in Uncategorized | Comments Off on Continuing a Loop After an Error

Configuration Changes in SSIS 2008

In a previous post, I detailed some of the challenges that I had encountered when trying to modify the connection string used for SQL Server configurations from the command line. In SSIS 2005, command line options were applied after the … Continue reading

Posted in Uncategorized | Comments Off on Configuration Changes in SSIS 2008

Mariner Wins Microsoft Performance Management Partner of the Year

This is really cool – Mariner (my employer) was awarded the Microsoft Performance Management Partner of the Year award this year, based on a solution that we created for the Charlotte-Mecklenburg Schools (CMS) system. When I was first told about … Continue reading

Posted in Uncategorized | Comments Off on Mariner Wins Microsoft Performance Management Partner of the Year

Updated Information on 64-bit Considerations for SSIS

Douglas Laudenschlager has posted some good information about the considerations you need to make if you are running SSIS on a 64-bit box. This is additional information to what is currently in Books Online, and it’s well worth looking at. … Continue reading

Posted in Uncategorized | Comments Off on Updated Information on 64-bit Considerations for SSIS

Calculating a Running Total Part 2

To finish up the topic that I started in my previous post, I wanted to post a more complex example of running total calculations. This is based off a request on the MSDN forums, for a running total calculation that … Continue reading

Posted in Uncategorized | Comments Off on Calculating a Running Total Part 2

Calculating a Running Total In SSIS

Running totals are a common calculation for reporting, and are occasionally needed in ETL processes to populate aggregate tables. One way to accomplish this in SSIS, if you are retrieving data from a relational database, is to do the running … Continue reading

Posted in Uncategorized | Comments Off on Calculating a Running Total In SSIS

SSIS Configurations At Design Time

There’s an interesting “behavior” that occurs with configurations at design time. The value of the configuration will be saved in your package as the new stored value. I’d seen this before, but never really thought about it, until a poster … Continue reading

Posted in Uncategorized | Comments Off on SSIS Configurations At Design Time