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(idtsmanagedcomponentwr...