Post reply

Migration from Oracle to SQL Server 2005

  • January 19, 2010 at 10:51 pm

    #136650

    I'm working on migration from Oracle 8.1.7 to SQL Server 2005.SSIS is used for this.

    I face the issue with date data. Oracle column have date "20/01/0018 00:00:00" (dd/mm/yyyy).

    but SQL Server would not accept date before 1753. I would like to convert this date to some predefined say 01/01/1753 00:00:00.

    How can i achieve this in SSIS.

    I use .Net source as source and OLE Db as destination. Which task I can have in between so that data is recognised if it does not fall in sql date limit change it to some default format

    Thanks

    Khushbu

  • January 20, 2010 at 1:40 pm

    #1106320

    You have to setup your source SQL statement to provide the date as string in the data flow. Then use standard Data Conversion transform to convert this string column to date. You can attach error output in case the conversion process fails and set your default date value using standard Derived Column tranform.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • January 21, 2010 at 5:49 am

    #1106622

    I achieved this by writing the select statement is source in a way that it converts the date less than year 1753 to 9999 and then pass it to destination(SQL Server table).

    this worked efficiently without having me add any additional tasks.

    May be this approach can help someone in need

    Best Regards

    Khushbu

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

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