none
SSIS ADO.NET connection manager ODBC Data Provider

    Question

  • Hi

    In my SSIS 2008 R2 package dataflow I am using the ADO.NET connection manager with ODBC Data Provider ( KISAM 32 BIT ODBC Driver, System DSN) to extract data from an external database

    In the SQL Command Text box I type in a very simple SELECT statement

    SELECT a from table_a

    When I select the PREVIEW button up the results come ok but when I execute the dataflow I get the error

    [ADO NET Source [153]] Error: Column "a" cannot be found at the datasource.

    Any ideas ?

    Regards

    Tim


    SQL DBA

    Thursday, September 05, 2013 6:48 AM

Answers

  • The preview is not a guarantee to a working package

    Very few non-Microsoft products support the RDS type of a cursor (this is what behind the scenes ADO is).

    KISAM must just one of them.

    Try using other options or drivers (I just has never came across this db this far).

    I am now shooting in the dark but it may be the .net that works.

    See http://blogs.msdn.com/b/mattm/archive/2008/03/04/connecting-to-mysql-from-ssis.aspx for more info.


    Arthur My Blog

    Thursday, September 05, 2013 6:04 PM