Getting error column name in SSIS 2016
Case In SQL 2016 CTP 2.3 Microsoft introduced a new simple way with to get the name of the column causing the error with some .NET code in a Script …
Search Suggest
VB.NET
VB.NET
Executing a PowerShell script in an SSIS package
Case I want to execute a PowerShell Script within an SSIS package, but there is no PowerShell task. How do I do that in SSIS? Solution There are 3 po…
Azure File System Task for SSIS
Case There is an upload and download task in the SSIS Azure Pack, but how can I delete a storage container in my Azure strorage account that was crea…
SQL Server 2016 CTP 2.3 Get error columnname
Case Before SSIS 2016 there was no way to get the name of the column that caused the error. Atleast not without a custom transformation or a very co…
Coming this year... Extending SSIS with .NET Scripting
It's not ready yet, but I'm proud to announce the first SSIS book by me and fellow MVP Régis Baccaro ( B | T ). Extending SSIS with .NET Scr…
Sending mail within SSIS - Part 2: Script Task
Case I want to send mail within SSIS, preferably HTML formatted. What are the options? Solutions There are a couple of solutions to mail within SSIS:…
Call SSIS 2012 Package within .Net application - Part 2
Case I want to start a SSIS 2012 package from a .Net application, but I want to use project variables and project connection managers. How do you do …
Split multi value column into multiple records
Case I have a column with multiple values and I want to split them into multiple records. Solution You could solve it with a fancy TSQL query. I saw …
Split multi value column into multiple columns
Case I have a source where one column has a divider that splits the sales values for each month. How do I split that value over multiple columns? Mo…