Post reply

Substring function

  • February 11, 2010 at 10:55 am

    #138091

    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

    #1117663

    Where are you trying to add this statement?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • February 11, 2010 at 11:06 am

    #1117668

    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

    #1117673

    You don't need a Script task for that - use a Derived Column instead.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • February 12, 2010 at 9:30 am

    #1118111

    It worked well....Thank you

    --VG

  • February 12, 2010 at 9:40 am

    #1118119

    Great, thanks for posting back.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply