Agile BI Community

I ran across an interesting behavior in SSIS this week, and thought it was worth sharing. Occasionally, I’ll have the need to use the value of a variable (set in the control flow) in the data flow. The typical way to accomplish this is to use a Derived Column transformation to introduce the variable’s value into the data flow. However, you need to ...

In SSIS 2005, one of the challenges with the Lookup transform was that the SQL used to populate the cache was fixed at design time. You could dynamically pass in parameters to the SQL, but only if you turned on the advanced caching options, which puts the lookup into row-by-row operation. With smaller tables (<100,000 rows) this wasn't too much ...

I use the Derived Column transform in the Data Flow a lot. In fact, I can't remember the last time I wrote a production package that didn't include at least one Derived Column transform in it. Over time, I've built up a lot of common expressions that I keep using, as well as some that I stored "just in case". I thought it would be good ...

I ran across a forum post today that highlighted a limitation with connection managers that I wasn't aware of, so I thought I'd post it here. If you have RetainSameConnection set to TRUE, and you are also trying to update the connection string through an expression, be aware the connection will not change to reflect the new connection string. ...