THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Browse by Tags
SQL Server 2016
SQL Server Community
SSIS Catalog Compare
SSIS Design Patterns
Use Catalog Compare to Migrate to the SSIS 2016 Catalog
I recently tried to use the SSISDB Upgrade Wizard to upgrade a restored SSISDB (backed up in an earlier version) to SQL Server 2016. It didn’t go well. I decided to use SSIS Catalog Compare to generate the scripts and ISPAC files from the previous instance, and deploy them to the SSIS 2016 Catalog. “You Can Do That?” Yes. Yes you can. Here’s ...
July 7, 2016
(Attempting to) Upgrade the SSIS Catalog to SSIS 2016
A couple people have asked me about upgrading the SSIS Catalog from previous versions to SQL Server 2016 so I decided to blog about it. The SSIS Catalog is an SSIS Execution Framework that ships with SQL Server versions starting with 2012. To execute SSIS packages using the Catalog, the SSIS project must be built using the Project Deployment ...
July 7, 2016
SSIS 2016 Administration: Create the SSIS Catalog
Creating an instance of the SSIS 2016 Catalog is identical to creating an SSIS Catalog in SQL Server 2012 or SQL Server 2014. Follow these steps to create an instance of the SSIS Catalog on SQL Server 2016. Open SQL Server Management Studio (SSMS) and connect to an instance of SQL Server. Once connected, open Object Explorer (if it is not already ...
June 15, 2016
Precon - SSIS Design Patterns and BIML: A Day of Intelligent Data Integration–8 Jan 2016, Alpharetta Georgia
I’m excited to announce I will be delivering a precon 8 Jan 2016 in Alpharetta Georgia for SQL Saturday 477 – Atlanta BI Edition titled SSIS Design Patterns and BIML: A Day of Intelligent Data Integration! This precon is all about DILM (Data integration Lifecycle Management). Abstract: SSIS Design ...
November 12, 2015
SSIS 2016 Supports Single-Package Deployment
One of the most anticipated features of SQL Server 2016 Integration Services (SSIS 2016) is support for deploying a single SSIS package from an SSIS project. “Why Is This A Big Deal, Andy?” I’m glad you asked. Consider the following scenario: You deploy version 1 of an SSIS Project containing 20 SSIS Packages to Production. ...
November 5, 2015
Brought to you by