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
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.