Take for 32 charcters

SSIS and Import/Export
1

How do I take the first 32 characters from a field using ssis.

2

what is the source of the data?

3

You use a derived columns transformation - and in that transformation you either add a new column or replace the existing column using SUBSTRING or LEFT functions.

1 Like
4

Please try this one

declare @mystring nvarchar(70)
set @mystring='abcdefghigklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz'

select @mystring, substring(@mystring,1,32) as first32chr, left(@mystring,32) as myfirst32string
5

I though I is an SQL script. you can use Derived column from Data Flow Transformation. It was answered now by jeffw8713..

6

thanks that worked perfectly