Data Conversion Issue in SSIS package - Text to GUID

I am developing a SSIS package that will open an Excel spreadsheet and import the data into a database table in SQL Server 2008. When I try to convert the Excel column data type: Unicode String [DT_WSTR] to a unique identifier data type: unique identifier [DT_GUID], I get the following error:

"Invalid character value for cast specification"

What do I need to do to resolve the conversion error?

Answers


I used a Derived Column Transformation Editor and to wrap the excel column value in squrly brackets {} in order for the SSIS package to properly convert the Unicode String into a GUID.


Need Your Help

username changes when launched under IIs and published

asp.net

I found a strange bug in programm( or may be not bug, I don't know)

Detect user restrictions for app store installation

ios app-store

If you have a link to the app store in your app that follows the itms:// convention, is it possible to check if the user has any restrictions related to installing apps?