Post reply

Failed to create an IDataAdapter object. This provider may not be fully supported with the Execute SQL Task

  • December 26, 2013 at 4:43 pm

    #287644

    I executed a simple query inside an execute SQL task -

    SELECT col1, col2

    from thetable

    where code = ?

    order by id asc

    Exec sql task - ADO.NET connection

    parameter "code" is an int32 in SSIS and int32 in parameter mapping of exec sql task.

    It works fine in SQL server, but in SSIS it causes the error -

    [Execute SQL Task] Error: Executing the query "SELECT col1, col2

    from thet..." failed with the following error: "Failed to create an IDataAdapter object. This provider may not be fully supported with the Execute SQL Task. Error message 'Incorrect syntax near '?'.'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

    How do I fix this error ?

  • December 27, 2013 at 1:17 am

    #1676043

    Try using an OLEDB connection instead.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • December 27, 2013 at 1:19 am

    #1676044

    Also, I think your parameter should be called '0' rather than 'code'.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • December 27, 2013 at 11:02 am

    #1676160

    Phil Parkin (12/27/2013)

    Try using an OLEDB connection instead.

    Yes, I gave up and decided to use an OLEDB connection instead. Still wondering why I got that error though. Google searches did not give me the answer.

Viewing 4 posts - 1 through 3 (of 3 total)

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