Handling or Importing GUIDs in SSIS
In big enterprise or organization, it is very common that they use GUIDs to uniquely identify each of Business Keys for any subject matter like EventIDs, RegistrationIds, or even the master data like Categories, hierarchies, etc. The reason behind using GUIDs is that a GUID is unique in nature across any platform, any server and at any point of time. The earlier versions of GUIDs contains encrypted MAC address with date component when it is got created. But in order to resolve individuals’ privacy issue, the algorithm got changed to more sophisticated form. Practically it’s a very huge number i.e. a 128 bit integer. We can store up to 2128 unique keys. So generating a same unique randomly twice is negligible.
The global representation of GUID is {00000000-0000-0000-0000-000000000000} and the digits on each place are dependent on the type algorithm used to generate the unique key. (format » {8-4-4-4-12}, total 36 characters including ‘-‘)
But SQL Server UniqueIdentifier data type stores GUID without including curly braces like 00000000-0000-0000-0000-000000000000. In this post, I will show how to import / export GUID columns from excel to SQL Server database by using SSIS.
Recent Comments