SSIS packages incompatibilities between SSIS 2008 and SSIS 2008 R2

Posted by Marco Russo (SQLBI) on SQL Blog See other posts from SQL Blog or by Marco Russo (SQLBI)
Published on Thu, 13 May 2010 22:46:00 GMT Indexed on 2010/05/13 22:56 UTC
Read the original article Hit count: 894

Filed under:
|
When you install SQL 2008 R2 workstation components you get a newer version of BIDS (BI Developer Studio, included in the workstation components) that replaces BIDS 2008 version (BIDS 2005 still live side-by-side). Everything would be good if you can use the newer version to edit any 2008 AND 2008R2 project. SSIS editor doesn't offer a way to set the "compatibility level" of the package, becuase it is almost all unchanged. However, if a package has an ADO.NET Destination Adapter, there is a difference...(read more)

© SQL Blog or respective owner

Related posts about Integration Services

Related posts about ssis