Skip to Content

Error while extracting data from Sybase using OLE DB in SSIS


I am having problems extracting data from Sybase using Advantage 11 OLE DB Provider in SSIS (2017). I can connect to the database, see the list of tables, and, when selecting a table as a data source I can see the columns.
However, when I click Preview (or run the data flow task), I get this error:

The provider cannot derive parameter information from the command. Use SetParameterInfo. (Advantage OLE DB Provider)

I am using no parameters, my Data Access mode is set to Table or View.

In project properties, Run64bitRuntime is set to False.

What am I missing? Thanks!!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

0 Answers