Showing posts with the label VB.NET

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…

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

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

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…

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

Sending mail within SSIS - Part 2: Script Task

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

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

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

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

Case I have a list of teacher and student combinations with one combination per record and I want t…

Load More That is All