Post reply

SSIS Extracting Error from PROGRESS Database

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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply