February 11, 2010 at 10:55 am
Hi,
How to read left 10 characters from a column (nvarchar(50)) in SSIS. This is not working Row.Column1 = SUBSTRING([column1], 1, 10), says Substring is not declared. I have to use this inside script task.
Thanks,VG
February 11, 2010 at 10:58 am
Where are you trying to add this statement?
February 11, 2010 at 11:06 am
My workflow like this : Oledb Source - Script task (read only 10 characters from a column) - data conversion task - flat file destination.
February 11, 2010 at 11:18 am
You don't need a Script task for that - use a Derived Column instead.
February 12, 2010 at 9:30 am
It worked well....Thank you
--VG
February 12, 2010 at 9:40 am
Great, thanks for posting back.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply