A quick blog post about an issue I encountered today. I tried deploying a simple SSIS project to my local SSIS catalog. No biggie. However, at the last step of the deployment I was greeted with the following .NET error: A .NET Framework error occurred during execution user-defined routine or aggregate “deploy-project-internal”: System.Data.SqlClient.SqlException: The locale […]
Tag: ssis
Webinar – Executing, Configuring and Scheduling SSIS 2016 Packages
I’ll be giving a webinar for MSSQLTips.com at March 30th. It’s a sponsored webinar, meaning there will also be a vendor to talk about JAMS, a scheduler that “runs, monitors and audits critical processes across a diverse array of servers and business applications”. Anyway, the title is Executing, Configuring and Scheduling SQL Server 2016 Integration Services […]
SSIS Naming Conventions 2.0
People who have been working for a while with Integration Services probably know the legendary blog post by SQL Server MVP Jamie Thomson: Suggested Best Practises and naming conventions. The blog post served as a guidance point for many SSIS projects regarding naming conventions of the various tasks and components. I still use them every […]
Overview of Published Articles – 2016Q3
Here is an overview of the articles I published in the third quarter of 2016. What’s New in SQL Server Integration Services 2016 – Part 1 What’s New in Integration Services 2016 – Part 2 Installing new SQL Server sample databases: WideWorldImporters Install SQL Server 2016 Sample Database: Wide World Importers Data Warehouse Generate more data […]
Webinar – What’s new in SSIS 2016
I’ll be giving a webinar on the new features of Integration Services 2016. When? August 11, 2016 Where? On the MSSQLTips.com website. You can register here. Abstract: SQL Server Integration Services is Microsoft’s leading data integration and transformation tool. In this webcast, we will take a look at which exciting new features SQL Server 2016 has […]
An update on AutoAdjustBufferSize in SSIS 2016
This week SQL Server 2016 Cumulative Update 1 was released and it contains a lot of updates/fixes for SSIS, SSAS, SSRS and MDS. If you are already working on SQL Server 2016, I’d urge to install this update as soon as possible. Anyway, one of the particular updates that caught my attention was Adds the adjusted […]
Reblog: Unexpected result with the File System Task
SQLKover update: nowadays you would probably use package parameters to pass the directory value. However, they still have a default value, so this still applies. Recently I ran across a forum thread where someone encountered an unexpected result when creating a directory using the File System Task in Integration Services. He used a variable to […]
Loading Data into Clustered Columnstore Index with SSIS
I’m using a clustered columnstore index (CCI) on one of my fact tables at a client. The row size is between 8 and 9 million rows and I was wondering how I could load data efficiently in this CCI using SSIS. I stumbled upon this MSDN blog post: SQL Server 2016 SSIS Data Flow Buffer […]
Overview of Published Articles – 2016Q1
Here is an overview of the articles I published in the first quarter of 2016. R Services series: SQL Server 2016 R Services: Executing R code in SQL Server SQL Server 2016 R Services: Display R plots in Reporting Services SSIS & AlwaysEncrypted: Reading Always Encrypted Data with SQL Server Integration Services 2016 Writing Always Encrypted […]
SSIS Trick: Adding Multiple Packages to a Project
A little SSIS trick today. Sometimes you start a new Integration Services project and you want to add some existing packages to this project. So you can right-click the SSIS Packages node and choose Add Existing Package. In the dialog, you choose the File System. All you now have to do is choose the package […]