August 8, 2009 at 12:58 am
Hi,
I am trying to transfer data from db2 to sql server database tables.
I am using an IBM oledb provider for db2. Its an onsite server database. We have rights only to query the database and we cannot see or do any other operations on database. When i create the connection manager using the provider IBM oledb provider for DB2, the server name i will give the ip address of onsite server. the initial catalog is in read only mode. When i try to run the package it gets cancelled. Can you plz help me out?
August 8, 2009 at 11:43 am
I don't think you can use SSIS with read only permissions to DB2 however you could use IBM ADO.NET provider to access read only data, if you are in SQL Server 2005 you may need full licensed VS2005/8 or use Express which means it is just ADO.NET operation and not SSIS.
The reason a while back I helped a user with DB2 automation it took a while for it to work and permission like in admin permissions in DB2 made the difference.
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply