This project is read-only.

SQL 2008R2-2012-2014 SSIS Framework BIDS Solution

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

Recommended Download

Source Code
source code, 1647K, uploaded Mar 20, 2014 - 1037 downloads

Other Available Downloads

Source Code
source code, 1264K, uploaded Mar 20, 2014 - 154 downloads
Source Code
source code, 2140K, uploaded Mar 26, 2014 - 169 downloads
Source Code
source code, 2093K, uploaded Apr 7, 2014 - 284 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.