After some digging I came up with the following way to connect to Informix database through SSIS in a Windows x64 environment.I had to go through stacks of IBM documentation, a lot of articles on the internet, and some trial and error before I reached a working solution.Eventually I was able to achieve the successful connection to an Informix database from an SSIS package (Works for Excel etc.
Hopefully this post will save you some leg work. Informix Connection Manager Download The ProductIts a freeware but you have to register on the IBMs website to download the product. Dont go for the 64bit versions unless you are working with BIDS 2008R2 or SQL 2012 Data Tools since anything before that (BIDS) is still a 32bit application, and your 64bit providers will not be shown on the providers list. You can download the latest version of client SDK from here. Otherwise you will prompt an error message saying add a prefix to path variable. Then install the product including IBM data server driver package. You can find Setnet32 application under All programsIBM Informix Client SDK. You will find the INFORMIXDIR and INFORMIXSERVER environmental variables are filled with values regarding to default server. After editing the service file, you can create a new Open Data Base Connection (ODBC). Informix Connection Manager .Exe To AddDont use Data Source Administrator tool in Program FilesAdministrative Tools instead use C:WindowsSysWOW64odbcad.exe to add and configure new data source. Give any data source name and fill appropriate connection details. Go to add new data source, you will find IBM OLE DB Provider for Informix is listed under OLE DB providers. Create new connection to the Informix server and have some fun with Data. I approach all projects with passion, diligence, integrity, and exceptional aptitude. I was trying to made a connection from SQL server to Informix DB to pull the data. All your steps are working fine until I reach OLE DB source Data flow task page. I will see if there is a way to connect directly to the informix databases via the ssrs report designer. Informix Connection Manager How To Control CookiesTo find out more, including how to control cookies, see here.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |