sql server - SSIS connection to Informix does not save password -
i'm using ssis 2012 connect informix database (avaya cms) via n ado net connection. i've set debugging run64bit false in project properties. should use 32bit informix openlink drivers.
we've got openlink odbc connection set works access , i'm able create connection manager in ssis with. when enter password in connection manager , test connection it's fine.
i go create ado net datasource , prompted input password. fine , can see tables cms , choose 1 data source.
when go preview errors: whole lot of
error [hy010] [openlink][odbc][driver]function sequence error
followed @ end
at system.data.odbc.odbcdatareader.nextresult(boolean disposing, boolean allresults) @ system.data.odbc.odbcdatareader.close(boolean disposing) @ system.data.odbc.odbcdatareader.close() @ microsoft.sqlserver.dts.pipeline.datareadersourceadapter.reinitializemetadata() @ microsoft.sqlserver.dts.pipeline.managedcomponenthost.hostreinitializemetadata(idtsmanagedcomponentwrapper100 wrapper)
does know causing , how can around it?
thanks
Comments
Post a Comment