SSIS - Load datetime/varchar/char to DB2 timestamp

• balasach82

  SSCrazy Eights

  Points: 9653

  More actions

  September 28, 2011 at 3:23 am

  #248785

  We are using SSIS 2005 to Load an table into DB2. One of the fields has datatype datetime/varchar in SQL i.e., it stores yyyy-mm-dd hh:mm:ss . We used both Datetime and varchar, but we are not able to load into an DB2 table which has timestamp datatype.

• HansB

  SSC-Addicted

  Points: 411

  More actions

  September 29, 2011 at 2:04 pm

  #1388626

  Try CONVERT(TIMESTAMP, --Your date column--)

  and see if that works? I am not too familiar with DB2. So if it doesn't work, my apologies.