Hi, i need to connect to db2 from my ssis,i know the driver is available for enterprise edition,but i am using standard edition.How to connect with sql2008r2 ssis to db2? Any othe will also be appreciated.

You should be able to use the IBM OLE DB Provider for DB2 http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/c0009064.htm Google (SSIS and IBM OLE DB Provider for DB2) http://www.google.com.au/search?source=ig&hl=en&rlz=&=&q=ssis+IBM+OLE+DB+Provider+for+DB2&aq=f&aqi=g-v1&aql=&oq= Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

Does these work for standard edition?? I am using Standard edition of Sql Server 2008 r2

I believe so. Did you try them?Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

i couldn't see any download link for IBM DB2 oledb provider in that url provided by you..and do i need DB2 Connect to have this?

Hi RAGS1109, Open http://blogs.msdn.com/b/dotnetinterop/archive/2006/01/19/oledb-provider-for-db2.aspx to download the provider. thanks, Jerry

Hi RAGS1109, Open http://blogs.msdn.com/b/dotnetinterop/archive/2006/01/19/oledb-provider-for-db2.aspx to download the provider. thanks, Jerry The OP would need Enterprise Edition to use this and they have already stated they don't have this edition.Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker