SQLTeam.com | Weblogs | Forums

Take for 32 charcters


#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.


#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