Showing posts with the label SCRIPT COMPONENT

Calculating Hash values in SSIS

Case I want to calculate a hash value for a couple of columns in SSIS. In T-SQL you can use HASHBYT…

Active Directory as Source

Case I want to use the users from my Active Directory in my Data Warehouse for an Employee Dimensio…

Dynamically unpivot data

Case For a client I need to read hundreds of bus route matrices and they all vary in size. This mak…

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…

Reading sensitive parameters in a script

Case I have a sensitive parameter in my package with a password in it. I want to use it in a Script…

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…

Creating BIML Script Component Transformation (rownumber)

Case I want to add a Script Component transformation to my bimlscript to add a rownumber functional…

Insert, update and delete records in CRM 2013 with SSIS - Part II: Inactivate records

Case A while a go I did a post on how to insert, update or delete records in CRM (2013), but what i…

Insert, update and delete records in CRM 2013 with SSIS - Part III: Add files as Annotation

Case I want to upload files to CRM Annotations with SSIS. I already uploaded contacts , but now I a…

Insert, update and delete records in CRM 2013 with SSIS

Case I have a business application with clients, accounts and other data and I want to make an inte…

Load More That is All