How to Load Unique Identifier Data From Excel to SQL Server Table in SSIS Package - SQL Server Integration Services(SSIS) Tutorial

In this video we will learn how to read Unique Identifier values from Excel Source/ Text File/CSV file and load to SQL Server Table.

When we use Derived Column Transformation to convert the Unique Identifier value to GUID by using DT_GUID Cast, it throw an Error.

To make it work , we need to use (DT_GUID) "{" +ColumnName+"}"

How to Convert/Cast Unique Identifier value in Derived Column Transformation - SSIS Tutorial

No comments:

Post a Comment