Handling unexpected data in SSIS

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,

Mani

Answer 1

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

Answer 2

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