Blog - Title

August, 2010

  • SSIS Team Blog

    Upcoming Product Changes

    • 10 Comments
    We’ve been hard at work on the next version of SQL Server, and it’s (almost) time to start sharing some of exciting new functionality we’ve introduced to SSIS. Over the new few months (starting about the time the first public CTP drops), I expect you...
  • SSIS Team Blog

    Speeding up Derived Column Transforms

    • 1 Comments
    A new technical note about splitting up transforms to increase performance has been posted on the SQLCAT site . It’s something you want to consider when you’re using synchronous transforms (like Derived Column, or Data Convert) to perform actions on a...
  • SSIS Team Blog

    Optimizing the Slowly Changing Dimension Wizard

    • 1 Comments
    As a follow-up to my previous post about SCD processing in SSIS , I thought I’d go deeper into using the built-in Slowly Changing Dimension Wizard . While there are definitely more efficient ways to do SCD processing in SSIS, there are some optimizations...
  • SSIS Team Blog

    String to Date conversion

    • 0 Comments
    This question recently came up on an internal SSIS mailing list: We’re converting date strings to date columns using the Derived Column transform. We’ve noticed some weird conversion behavior with older dates, like ‘0001-01-01’. It seems that year values...
Page 1 of 1 (4 items)