Post reply

Oracle data types in SSIS Execute SQL Task

  • May 28, 2008 at 8:59 am

    #121626

    Sorry, I posted my SSIS question in the Oracle part of the forum. I need some help with data type issues, here's the original post: http://www.sqlservercentral.com/Forums/Topic507718-1042-1.aspx

    nat

  • May 29, 2008 at 1:38 am

    #821624

    Hey Nat,

    Not that I have ever tried to convert data from Oracle, but I do know that SSIS is very finicky about handling Nulls.

    How about using an ISNULL equivalent in Oracle (I think it is COALESCE or something).

    Then when you have a blank recordset, it will return you 0 as opposed to NULL

    If you absolutely HAVE to have nulls (on counts it is rare to have mandatory Nulls), you may want to check your destination as well to see if the allow nulls option is selected

    Good luck

    ~PD

  • May 30, 2008 at 2:19 pm

    #822550

    I ended up using CAST to return a string value, then converted it back to a number in another step.

    Thanks!

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

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