Previously I wrote a blog on how to do a for each loop to look through each col in an SSIS data flow here . Well things have changed since I wrote that blog, in fact I believe that old code only works in SSIS 2005. So I thought I would be good to update to SSIS 2008 and show you new and better way to loop through all of the columns in a script tasks. You could do the same work with a derived column. The problem comes when you have hundreds of columns and you need to do the same work on eac...
Read More
SQL Saturday 85 in Orlando , FL on September 24, 2011 was a great event. The people putting it together did a great job of putting on the event. The logistics on these events must be a daunting tasks and they handled it perfectly. I would like to personally thank Bradley Ball ( Blog | Twitter ), Karla Landrum( Blog | Twitter ), and Shawn McGehee( Blog | Twitter ) for the work they did to put this SQL Saturday. I apologize to anyone I left out. In my first session I covered SSIS Script tasks. You...
Check out this cool Infomercial Pragmatic Works made about BI xPress. http://pragmaticworks.com/landing/bixpressinfomercial.aspx
My SSIS White Paper has been published! Download the White Paper and the Sample Files here. "SSIS is a fantastic Microsoft tool for performing Extract Transform and Loading (ETL) procedures. A challenge in SSIS is identifying a problem once you deploy your packages. In this webinar you will learn how to both identify and solve your SSIS issues." REGISTER NOW! What you'll learn: ? How to set up auditing on SSIS packages ? How to set up logging on SSIS packages ? How to use both native t...
I?m very proud to announce that Pragmatic Works will be presenting a Business Intelligence Workshop pre-con for SQLSaturday #85 in Orlando on Friday September 23rd! In this session you?ll have not one, not two, not three but FOUR Pragmatic Works consultants walking you through how to develop a full business intelligence solution from the ground up! Your instructors for this awesome pre-con are: Jorge Segarra ( Twitter | Blog ) I?m a BI Consultant for Pragmatic Works and a SQL Server MVP. In addi...