Previously I could get a connection but only through ADO.NET and could only use this to connect to tables or queries without parameters. NOTE TO ALL SSIS DEVELOPERS: If you have downloaded ODBC drivers elsewhere and now have a listed 32 bit driver that should work but doesn't or one that provides the server or file name box but has the authentication boxes disabled (greyed out), then follow this simple article exactly and you will get everything working. This has really helped me out, given the complete load of tosh that is the IBM web site that offers loads of help that is anything but helpful and basically just led me down the wrong route and took days to understand. Total and unreserved thanks for this fantastic article. Then install the product including IBM data server driver package. Otherwise you will promt an error message saying add a prefix to path variable.
The next step is to add a path to "C:\Windows\SysWOW64" to the begining of the path environmental variable before installing the client SDK. You can download the latest version of client SDK from here. Don't go for the 64bit versions since BIDS is still a 32bit application, your 64bit providers will not be shown on the providers list.
It's a freeware but you have to register on the IBM's website to download the product.
But the experience I have gathered lead me to achieve the connection sucessfully and it's drive me to write an article on how to create connection between Informix through SSIS.įirst download the latest version of Informix Client Software Development Kit (32bit) from IBM's website. I went through lot more articles on the internet, but couldn't be able to find a proper direction. I was quite confused to find a way to connect Informix database through SSIS in Windows 圆4 environment few days back.