There are several ways to stop and executing SSIS package. If the package is executing in the SSIS Catalog, you can use the SSISDB.[catalog].stop_operation stored procedure. Stop_operation has one parameter – a bigint named @operation_id. You can execute the stored procedure thus: exec SSISDB.[catalog].stop_operation @operation_id = <operation_id>; You can obtain the operation_id of an executing …
Continue reading Stop an SSIS Package
Author:Andy Leonard
Nine Years
Exactly nine years ago I published my very first post here at SQLBlog.com titled SSIS Design Pattern – Incremental Loads. At the time I wrote this post, the last page of my blog dashboard appeared as shown in the screenshot above. It shows the Incremental Loads Design Pattern post has received over 230,000 views in …
Continue reading Nine Years
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 …
Continue reading Use Catalog Compare to Migrate to the SSIS 2016 Catalog
(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 …
Continue reading (Attempting to) Upgrade the SSIS Catalog to SSIS 2016
Use Biml to Remove Spaces from Flat File Column Names
I hate a space in a database column name. Kent Bradshaw and I are updating our demo for loading National Provider Index (NPI) file data (We plan to present on this soon… more later…). The NPI files currently have 329 fields and almost every one of them contains spaces: I had 5 minutes, so I …
Continue reading Use Biml to Remove Spaces from Flat File Column Names
PASS Updates to Speaker Contracts
Adam Jorgensen, PASS President, has posted an update about the PASS speaker contract: Contributions to the Speaker Contract. Included in the post are links to the updated versions of the Summit Speaker Contract and the Summit Pre-Conference Contract. PASS leadership has put more time into this issue than they planned to and I applaud their …
Continue reading PASS Updates to Speaker Contracts
PASS Summit 2016 Speakers
I commend PASS, the PASS Board, and PASS leadership for all their hard work putting together this year’s PASS Summit. From the looks of the lineup of presenters and presentations the PASS Summit 2016 is going to be another awesome event! Allen White (@SQLRunr) serves as PASS Programs Director. Although Allen has been actively engaged …
Continue reading PASS Summit 2016 Speakers
Migrating SSIS Projects and Parameters, Part 1 is Live at SQL Server Central!
Have you ever moved an SSIS project from one SSIS Catalog to another? With Catalog Environments and References? If you haven’t, you may be in for a surprise when you try. First, why should you try? “SSIS is software development.” – Andy, circa 2008 Best practices for software development apply to SSIS. One of those …
Continue reading Migrating SSIS Projects and Parameters, Part 1 is Live at SQL Server Central!
SSIS 2016: Building and Deploying a Simple Test Project
All software is tested. Some, intentionally. – Andy, circa 2010 I test software a lot. Why? Because all software is tested. Some software is tested intentionally. Some is tested by your soon-to-be-former-largest-customer. In this post I will show you how to build and deploy a very simple SSIS 2016 project and deploy it. Cool? Let’s …
Continue reading SSIS 2016: Building and Deploying a Simple Test Project
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 …
Continue reading SSIS 2016 Administration: Create the SSIS Catalog
