Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Working with Oracle Dates with SSIS Expand / Collapse
Author
Message
Posted Wednesday, April 03, 2013 10:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 24, 2013 8:33 AM
Points: 1, Visits: 42
I am trying to create an SSIS package that copies employee data from an Oracle database and insert it into a SQL 2005 database table.

When using PL/SQL with the following query, I get "01/01/1700" for the TERM_DATE AND LAST_DAY_PAID for all active employees. I need to convert this date to NULL when entering it into the SQL table.

SELECT     COMPANY, EMPLOYEE, EMP_STATUS, ADJ_HIRE_DATE, DATE_HIRED, TERM_DATE, LAST_DAY_PAID
FROM PRODLAW.EMPLOYEE


COMPANY EMPLOYEE EMP_STATUS ADJ_HIRE_DATE DATE_HIRED TERM_DATE LAST_DAY_PAID
2 290104 A1 07/21/1997 07/21/1997 01/01/1700 01/01/1700
2 7013 T1 04/03/2012 04/03/2012 05/23/2012 06/01/2012


When I created the SSIS package, the active employees, with the 01/01/1700 in the TERM_DATE AND LAST_DAY_PAID do not come through using the same query.

Any help would be appreciated.
Post #1438484
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse