Working with Oracle Dates with SSIS

• Jeff Baisch-303625

  Newbie

  Points: 5

  More actions

  April 3, 2013 at 10:45 am

  #394517

  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

  COMPANYEMPLOYEEEMP_STATUSADJ_HIRE_DATEDATE_HIREDTERM_DATELAST_DAY_PAID

  2 290104 A1 07/21/199707/21/199701/01/170001/01/1700

  2 7013 T1 04/03/201204/03/201205/23/201206/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.