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 ] Error: Column "a" cannot be found at the datasource.
Any ideas ?
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
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?