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 c…
Showing posts with the label VB.NET
Executing a PowerShell script in an SSIS package
byHOIT
Case I want to execute a PowerShell Script within an SSIS package, but there is no PowerShell task.…
Azure File System Task for SSIS
byHOIT
Case There is an upload and download task in the SSIS Azure Pack, but how can I delete a storage co…
SQL Server 2016 CTP 2.3 Get error columnname
byHOIT
Case Before SSIS 2016 there was no way to get the name of the column that caused the error. Atleast…
Coming this year... Extending SSIS with .NET Scripting
byHOIT
It's not ready yet, but I'm proud to announce the first SSIS book by me and fellow MVP Rég…
Sending mail within SSIS - Part 2: Script Task
byHOIT
Case I want to send mail within SSIS, preferably HTML formatted. What are the options? Solutions Th…
Call SSIS 2012 Package within .Net application - Part 2
byHOIT
Case I want to start a SSIS 2012 package from a .Net application, but I want to use project variabl…
Split multi value column into multiple records
byHOIT
Case I have a column with multiple values and I want to split them into multiple records. Solution …
Split multi value column into multiple columns
byHOIT
Case I have a source where one column has a divider that splits the sales values for each month. H…
Creating a comma separated list of related records
byHOIT
Case I have a list of teacher and student combinations with one combination per record and I want t…