-
Recent Posts
Recent Comments
Archives
- April 2013
- November 2012
- February 2012
- January 2012
- December 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
Categories
Meta
Monthly Archives: May 2007
Dynamically Unpivoting Columns to Rows
There’s been a few questions on the forums recently about taking column values and pivoting them to rows. For example, I might have an input file with 5 columns: a key column and 4 category columns. Key; C1; C2; C3; C41;1;2;3;42;1;2;3;43;1;2;3;44;1;2;3;4 … Continue reading
Posted in Uncategorized
Comments Off
BIDS Helper 0.9 Beta is Released
The 0.9 beta of BIDS Helper has been released on CodePlex. It’s got a lot of great features for working with Analysis Services, and some future enhancements will include SSIS.
Posted in Uncategorized
Comments Off
Handling Varying Columns, Part 2
In Handling Flat Files with Varying Numbers of Columns, I showed an example of parsing a flat file with an inconsistent number of columns. I used a script component, but Jamie commented that the same thing could be accomplished through … Continue reading
Posted in Uncategorized
Comments Off
Handling Flat Files with Varying Numbers of Columns
5/15 Update – I added Part 2 to show how to do the same thing with a Conditional Split and a Derived Column transform, per Jamie’s feedback (see the comments on this post). A common question on the forums has been how to … Continue reading
Handling Multiple Errors in SSIS
[edited on 12/14/2007 to correct an error in the text around string handling - the samples were not modified] One actual failure in SSIS can trigger a whole series of error messages. For example, failure to convert a column value … Continue reading
Checking for Overlapping Rows in a Slowly Changing Dimension
A question was posted on the MSDN forums about validating that there are no overlapping rows in a slowly changing dimension (SCD). It is common to use a start and end date in a type 2 SCD to designate when … Continue reading
Posted in Uncategorized
Comments Off