Is it possible to Convert UNIQUEIDENTIFIER to INT in SSIS ?. If possible please help me the same. Thanks Anil

Is it possible to Convert UNIQUEIDENTIFIER to INT in SSIS ?. No, because UNIQUEIDENTIFIER is 128 bits whereas INT is only 32 bits, including the sign bit. What is your use case for needing to do this? Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/

HI Dan, thanks for your reply.. I have a requirement to Map source unique-identifier value to Int data type column. Thanks Anil

If you just need a map then you could set up a relationship table which contains your GUID and an identity column. Or add an identity column to your table which has the guid. This would allow a mapping but would not be a map to int that you could perform via a calculation, you would have to look it up in the table. What is the purpose of the requirement? Chuck Pedretti | Magenic North Region | magenic.com