Add DB2 ADO.NET to the drop-down list of available connection managers
I can't seem to find anything on how to add a new connection manager provider. Can you help?
I have added reference IBM.Data.DB2.iSeries to my C# Visual studio so this proves I have the IBM Client-Access available on my Windows 7 laptop.
But I want to be able to use ADO.NET for iSeries in a package that I am setting up with the SSIS GUI, i.e. no scripting involved.
Regards, Frank
October 22nd, 2011 8:14am
Hi FrankMarshall,
Please refer to the following articles,
http://www.vsteamsystemcentral.com/cs/blogs/applied_team_system/archive/2006/04/27/66.aspx
http://sqlserverpedia.com/blog/sql-server-bloggers/etl-method-%E2%80%93-fastest-way-to-get-data-from-db2-to-microsoft-sql-server/
Hope that helps.
Thanks,
Eileen
Free Windows Admin Tool Kit Click here and download it now
October 25th, 2011 8:34am
Hi FrankMarshall,
Please refer to the following articles,
http://www.vsteamsystemcentral.com/cs/blogs/applied_team_system/archive/2006/04/27/66.aspx
http://sqlserverpedia.com/blog/sql-server-bloggers/etl-method-%E2%80%93-fastest-way-to-get-data-from-db2-to-microsoft-sql-server/
Hope that helps.
Thanks,
Eileen
October 29th, 2011 2:10am