Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Tracking columns in type 1 in SSIS packages

Status
Not open for further replies.

BeeTrees

IS-IT--Management
Nov 6, 2017
5
CA
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top