Handling unexpected data in SSIS RRS feed

  • Question

  • Hi,

    Please post your suggestions / guidelines that are common and should be followed in SSIS package development. Need more information on Error Handling.

    We have migrated SQL Server from 2008 R2 to 2014. We have set of packages developed in older version and those have to be revamped implementing new features that are applicable.

    Please list the common/essential new features which we can implement to improve the performance, easy maintance etc.

    Thank You,


    Tuesday, April 12, 2016 8:05 AM


All replies

  • Hi Manibala,

    1. Project deployment model

    2. All the error/Jobs metadata/Package metadata details get from SSISDB

    3. Package to Project level parameters

    Please mark as answer if my post is helped to solve your problem
    and vote as helpful if it helped so that forum users can benefit 

    Srinivasarao G, MCSE(Business Intelligence) Blog:http://sqlcart.blogspot.com

    Tuesday, April 12, 2016 9:02 AM
  • Hi Manibala,

    The BOL: What's New (Integration Services) for SQL Server 2014 states it is unchanged from the previous release.

    So you can check BOL:What's New (Integration Services) for SQL Server 2012.

    Regarding performance aspect, as per the BOL, only Merge and Merge Join Transformations have got improved.

    Eric Zhang
    TechNet Community Support

    • Proposed as answer by Eric__Zhang Tuesday, April 19, 2016 9:37 AM
    • Marked as answer by Eric__Zhang Sunday, April 24, 2016 10:39 AM
    Wednesday, April 13, 2016 6:40 AM