SQLTeam.com | Weblogs | Forums

Take for 32 charcters


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