There are multiple issues which one can run into while importing data from Excel to SQL server. Although SSIS has pave quite a easy way to accomplish this task but failing to paying attention to details can run us into multiple issues.
In this part we will be discuss the issue related to column from excel with Uniqueidentifier data in it.
I have an excel file (GUIDShow) with following column structure and data in GUIDDesti sheet
ID - Int
UniqueId - String
In this part we will be discuss the issue related to column from excel with Uniqueidentifier data in it.
I have an excel file (GUIDShow) with following column structure and data in GUIDDesti sheet
 |
| Excel Data |
ID - Int
UniqueId - String
