Post reply

Super Scripts are not loading into SQL server in SSIS while loading from Teradata ODBC

  • September 21, 2015 at 4:31 am

    #304755

    If we use the ANSII in the odbcad32 setup while loading the data from Teradata to SQL server we won't get the super scripts in SQL server.

    To Avoid this use UTF8 in the Session character set of the ODBCSet up for Teradata or any other database if you are using the ODBC in you SSIS package.

    If you want to use the super scripts in SQL server you can use like below -

    For ex: you want to use Trade mark symbol-

    declare @name varchar

    set @name='Venkatesh'

    Select @name+char(153)

    it will return venkatesh+superscirpt(TM)

  • September 21, 2015 at 4:48 am

    #1828042

    venkatesh.jonnagadla (9/21/2015)

    If we use the ANSII in the odbcad32 setup while loading the data from Teradata to SQL server we won't get the super scripts in SQL server.

    To Avoid this use UTF8 in the Session character set of the ODBCSet up for Teradata or any other database if you are using the ODBC in you SSIS package.

    If you want to use the super scripts in SQL server you can use like below -

    For ex: you want to use Trade mark symbol-

    declare @name varchar

    set @name='Venkatesh'

    Select @name+char(153)

    it will return venkatesh+superscirpt(TM)

    Is this a question?

Viewing 2 posts - 1 through 2 (of 2 total)

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