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…
Showing posts with the label SCRIPT COMPONENT
Active Directory as Source
byHOIT
Case I want to use the users from my Active Directory in my Data Warehouse for an Employee Dimensio…
Dynamically unpivot data
byHOIT
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
byHOIT
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
byHOIT
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
byHOIT
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)
byHOIT
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
byHOIT
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
byHOIT
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
byHOIT
Case I have a business application with clients, accounts and other data and I want to make an inte…