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

Popular posts from this blog

c++ - QTextObjectInterface with Qml TextEdit (QQuickTextEdit) -

javascript - angular ng-required radio button not toggling required off in firefox 33, OK in chrome -

xcode - Swift Playground - Files are not readable -