Microsoft makes a pretty good OLE DB Provider for DB2 that you can use for SSIS, DTS, and linked servers under SQL Server. It's sometimes difficult to configure but you can get some good starter settings here.
In yet another remarkable but not uncommon blunder on their part, Microsoft's installation package will only install the provider on a server with Enterprise or Developer Edition. Why they do this I don't know, but if you have a Standard Edition SQL Server and want to use this provider, here's a workaround:
- Install Enterprise or Developer Edition side-by-side on your Standard Edition server as a named instance, only the database engine components.
- Install the DB2 OLEDB Provider.
- Uninstall the side-by-side instance. Or keep it if you like it and have a valid license.
- I've only tested this with Standard Edition, but I believe it will work with any edition of SQL Server.
- You may be able to use a trial version of SQL Server for the side-by-side install, I haven't tested it.
- This technique also works for SQL Server 2000 instances, as long as your side-by-side instance is 2005 or higher
If you're wondering why I'm posting this: <rant>
- It was in answer to this Tweet.
- I'm aggravated that Microsoft:
- Makes a great product
- That they give away for free
- And deprive their user base with a ridiculous and unnecessary SKU limitation
Sorry MS if you don't agree, but DB2 integration is NOT an Enterprise-only feature, nor one that should cost $30K+ to get. If you really think so, then charge $30K for the provider, don't tease your customers with a freebie.