Home Forums Data Warehousing Integration Services Failed to create an IDataAdapter object. This provider may not be fully supported with the Execute SQL Task RE: Failed to create an IDataAdapter object. This provider may not be fully supported with the Execute SQL Task

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