SQL 2008R2-2012-2014 SSIS Framework BIDS Solution

Rating: No reviews yet
Downloads: 1596
Released: Mar 19, 2014
Updated: Nov 3, 2014 by sqlarchitect
Dev status: Stable Help Icon

Recommended Download

Source Code SSIS2012-Package-Framework.zip
source code, 1647K, uploaded Mar 20, 2014 - 1008 downloads

Other Available Downloads

Source Code SSIS2008R2Framework.zip
source code, 1264K, uploaded Mar 20, 2014 - 149 downloads
Source Code SSIS2012-SSISSDB-Framework.zip
source code, 2140K, uploaded Mar 26, 2014 - 165 downloads
Source Code SSIS2014-SSIDB-Framework-VS2013.zip
source code, 2093K, uploaded Apr 7, 2014 - 274 downloads

Release Notes

3/19/2014 - This is the initial release of the framework for SQL2008R2.

3/20/2014 - I modified two sql scripts that create dummy objects to add IF NOT EXISTS...

3/20/2014 - The SQL2012-Package-Framework is a conversion of the SQL 2008 packages. This is for people that want to continue to use a package/file approach with SSIS 2012. The main changes in the conversion are running the packages through the conversion wizard, renaming packages, rebuilding script tasks, changing the reference location for Microsoft.AnalysisServices.dll, and reformatting to accommodate graphic differences between SQL 2008 R2 and SQL 2012 SSIS GUI's.

3/26/2014 - Added the SQL 2012 SSISDB Catalog framework. The catalog framework uses project parameters and environments. In order to get the copy and paste approach to work, the packages use package connections. The ODBC connection strings for moving data from source to staging are set at the package level.

4/7/2014 - Added the SQL 2014 SSISDB Catalog frame. Follows same pattern as the SQL 2012 Catalog Framework. SQL 2014 was done with Visual Studio 2013.

Reviews for this release

No reviews yet for this release.