CODEWITHSUNDEEP
ssis
a1exis
a1exis

Reputation: 39

Cannot cast expression in SSIS

I have table with field AccountId, which type is DT_NTEXT. I need to cast it to DT_GUID

I use transformation "Derived Column". Expression is (DT_GUID)[AccountId]

But SSIS throw an error TITLE: Cannot cast expression "(DT_GUID)AccountId" from data type "DT_NTEXT" to data type "DT_GUID". The requested cast is not supported.

May be there is some workaround?

Upvotes: 0

Views: 1349

Answers (1)

billinkc
billinkc

Reputation: 61249

Try a series of casts. I'm guessing it's something like DT_NEXT -> DT_WSTR -> DT_GUID

Upvotes: 1

Related Questions