Hi All,
I have packages in SSIS having certain columns taking part in type 1 change. I can only get to know about those fields by opening each package and look into the code. I just want to fix this issue and have a solution to get list of columns taking part in type 1 change.
In packages, the columns enclosed in the HASHBYTES function in the IIF block are the columns undergoing type 1 changes.
Is there any way to know what columns are in type 1 changes for any dimension, and a way to update the list of columns when required.
Thank You All.
I have packages in SSIS having certain columns taking part in type 1 change. I can only get to know about those fields by opening each package and look into the code. I just want to fix this issue and have a solution to get list of columns taking part in type 1 change.
In packages, the columns enclosed in the HASHBYTES function in the IIF block are the columns undergoing type 1 changes.
Is there any way to know what columns are in type 1 changes for any dimension, and a way to update the list of columns when required.
Thank You All.