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 …
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…