Blogs
Welcome to EMC Consulting Blogs Sign in | Join | Help

Welcome to EMC Consulting Blogs

Browse by Tags

All Tags » Dataflow Task » Expressions

  • SSIS Nugget: Conditionally email a file containing error rows

    Someone emailed me today asking: I have an SSIS package that outputs data that can’t be inserted into destination tables into flat log files [JT: I presume he means that error rows are redirected to a flat file] What is the easiest way to then after processing has completed: A) Check to see whether there has been any data that could not be ...
    Posted to SSIS Junkie (Weblog) by jamie.thomson on July 11, 2008

  • SSIS: Dataflow expressions

    Did you know that it is possible to set expressions on components within the dataflow? Expressions on data-flow components was virtually the very last feature that was added to SSIS 2005 prior to RTM. All components CAN support expressions on their custom properties, the component developer decides whether or not it WILL by setting ...
    Posted to SSIS Junkie (Weblog) by jamie.thomson on October 9, 2007

  • SSIS: Suggested Best Practices and naming conventions

    I thought it would be worth publishing a list of guidelines that I see as SSIS development best practices. These are my own opinions and are based upon my experience of using SSIS over the past 18 months. I am not saying you should take them as gospel but these are generally tried and tested methods and if nothing else should serve as a basis ...
    Posted to SSIS Junkie (Weblog) by jamie.thomson on January 5, 2006
EMC2, EMC, and where information lives are registered trademarks of EMC Corporation.
All other trademarks used herein are the property of their respective owners.                  
© Copyright 2009 EMC Corporation. All rights reserved.                                                    
Powered by Community Server (Personal Edition), by Telligent Systems