Post reply

Special charecter (') in DTS

  • September 10, 2008 at 7:28 am

    #127392

    Hi,

    I have VB script task in one the DTS package.

    It transfer the data of column 'Managername' to other table.

    The problem here is that the manager name has special charecter(') in the data like "O'Dwyer Sean" in the data.

    The DTS showing an error message here at the specail charecter (').

    I want the whole string to be transfered to destination table including (') also?

    Is there any way?

    Thank You

  • September 10, 2008 at 11:53 pm

    #870116

    Could some one help me out please?

    Thank You

  • September 11, 2008 at 1:10 pm

    #870589

    not sure if this will work (don't have time to test it myself right now). replace single tick (') with two single ticks (''). note: not a double tick ("), but two single ticks ('').

  • September 15, 2008 at 3:27 pm

    #872050

    Replace "'" with char(39) and pass that, instead.

Viewing 4 posts - 1 through 3 (of 3 total)

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