Welcome to Agile BI Community Sign in | Join | Help

June 2008 - Posts

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 is invalid, you want to continue processing the remaining Read More...
Posted Sunday, June 29, 2008 1:32 AM by jwelch | 0 Comments
Filed under: ,

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 configurations Read More...
Posted Friday, June 20, 2008 10:36 PM by jwelch | 0 Comments

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 the award, Read More...
Posted Thursday, June 19, 2008 5:52 AM by jwelch | 0 Comments
Filed under:

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. Considering Read More...
Posted Thursday, June 12, 2008 9:09 PM by jwelch | 0 Comments
Filed under: ,

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 would “slide” along as additional rows Read More...
Posted Thursday, June 12, 2008 1:18 AM by jwelch | 0 Comments
Filed under: , ,

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 total in Read More...
Posted Monday, June 09, 2008 4:33 AM by jwelch | 1 Comments
Filed under: , ,

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 on the forums Read More...
Posted Wednesday, June 04, 2008 5:58 PM by jwelch | 0 Comments
Filed under: ,