Converting BlobColumn to String in SSIS Script Component.

Question

Hello..

How to convert BlobColumn to String in SSIS Script Component.

Ex: Source Column : OrganisationProviderID NVARCHAR(MAX) Destination Column : OrganisationProviderID VARCHAR(20)

How can this be acheived in SSIS Script Component

Thanks

Answer 1

Why are you using the script component for this? Also, i'm not sure that a NVARCHAR(MAX) really qualifies as a BLOB column.

If you want to do it as part of a data flow task, on your Data Source, set the data access mode to 'SQL Command' then use the following command text:

select left(OrganisationProviderID,20) as OrganisationProviderID
from src

Then link this to your destination component.