SSIS Extracting Error from PROGRESS Database

• sqlquery29

  Ten Centuries

  Points: 1319

  More actions

  June 14, 2018 at 1:12 am

  #370795

  Good Day

  I am facing the below error while extracting source data from a PROGRESS database into Staging Database. We are doing full dump of the Source Data. Have created a Linked server for the Progress DB and trying to extract from there.

  Msg 8114, Level 16, State 10, Line 1
  Error converting data type DBTYPE_DBDATE to date.

  Source DB : Progress
  Target DB : SQL Server

  Have tried using CAST ,CONVERT , TRY_CONVERT & TRY_CAST but nothing is working.

  
  Thank You...

• Jo Pattyn

  SSC-Dedicated

  Points: 32430

  More actions

  June 14, 2018 at 7:25 am

  #1993992

  Have you tried a textual dump of the offending field to see what value might give the error?
  
SELECT dateasstring from openquery(progresssource,'select tostring(offendingfield) dateasstring ...') progress

  tostring: not sure what the casting function is in progress