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

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

  • Try using an OLEDB connection instead.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

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

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • 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