Using ssis and db2

Hi,

I'm using ole db driver for db2 in ssis. I'm able to connect to the db2 server successfully. However there is a scheme called PVITA, I can't map the source to any tables because no tables show up in the drop down. How do I make the connection to the schema?
LVL 1
Auerelio VasquezETL DeveloperAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Auerelio VasquezConnect With a Mentor ETL DeveloperAuthor Commented:
I was able to fix this issue by changing to an odbc connection, then I was able to type the schema.tablename. All works now
0
 
funwithdotnetCommented:
It's been a long time (five years) since I did the DB2 <> SQL Server thing. I believe there was a disc that came with the DB2 install with the Windows support tools. One of these tools made it pretty easy.

I used pretty much everything IBM had for DB2 support on Windows. iAccess, IBM Data Server, some other .NET providers.  I'm pretty sure it was one of the IBM tools that I used for nightly SQL jobs. I handled real-time queries from .NET applications via SQL Server, so there were no provider libraries in any applications. (I looked up a couple of them, just for you.) It was all done DB2 <> SQL Server. I'm also pretty sure I had no schema issues.

My apologies that it isn't more insightful. Perhaps it'll help point you in the right direction.

Good luck!
0
 
DcpKingCommented:
Compare the permissions that you have for PVITA with those for some other schema that you're succeeding with. Are they different?
0
 
Auerelio VasquezETL DeveloperAuthor Commented:
Thanks
0
All Courses

From novice to tech pro — start learning today.