Post reply

Convert FROM SQL BOOLEAN TO ORACLE INT

  • July 20, 2009 at 12:21 am

    #132099

    Hi ,

    I am making a SSIS job to transfer data from SQL Server to Oracle database which have the same schema.

    Now in one of my tables in SQL a column is of data type BOOLEAN but the corresponding column in the same table in Oracle is Integer.

    So while transferring the data from SQL to Oracle i want to typecast this column value from Boolean to Integer.

    Can you guys please help me doing the same in SISS.

    Thanks and Regards

    Shobhit Bansal

  • July 20, 2009 at 2:52 pm

    #1027296

    duplicate post.

    for future discussion please see

    http://www.sqlservercentral.com/Forums/FindPost755525.aspx


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

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

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