Post reply

OLE DB Source [1]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "ASAProv.90" Hresult: 0x80004005 Description: "Cannot convert parameter 2 to a DBTYPE_STR".

  • May 2, 2010 at 4:37 am

    #142800

    Cannot convert parameter 2 to a DBTYPE_STR" SSIS

    I am new to this SSIS Package please help me

    I am using Syabse is source and SQL server is destination database

    I am getting below error

    I have taken two global string variables

    I have call procedure like below

    From OledDB Source we are calling like “EXEC INSGT_karunakar ?,?”

    I am getting below error

    Can you please help me

    [OLE DB Source [1]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "ASAProv.90" Hresult: 0x80004005 Description: "Cannot convert parameter 2 to a DBTYPE_STR".

    What setting need to be done for this above error

    Procedure name

    ----------------------------------------------------------------------------------------------------------------------------------

    CREATE procedure DBA.INSGT_karunakar(@last_dt_time varchar(30),@DTSCurrentStartDate varchar(30))

    as

    begin

    select Code, Description

    from

    dba.Codes_RequestsAction

    end

    ----------------------------------------------------------------------------------------------------------------------------------

  • May 3, 2010 at 8:02 am

    #1161282

    My first guess, after reading your chaos question two times (:-P), is that you are trying to convert a date to a string, and it is failing. That is, if @DTSCurrentStartDate is a date.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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