How do I take the first 32 characters from a field using ssis.
what is the source of the data?
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.
Please try this one
declare @mystring nvarchar(70) set @mystring='abcdefghigklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz' select @mystring, substring(@mystring,1,32) as first32chr, left(@mystring,32) as myfirst32string
I though I is an SQL script. you can use Derived column from Data Flow Transformation. It was answered now by jeffw8713..
thanks that worked perfectly