> From: Gerd Forthmann > I don't think it is an ODBC problem since SSIS > connection managers unlike DTS don't use ODBC. They > use OLEDB and connect even without the IBM U2 ODBC > driver installed.
In response to concerns expressed here and in all other posts like this, I've written a blog that describes a better approach, and a successful solution that implements the approach. See "SQL Server and MV - Part 1" published today in my blog. > If anybody has any suggestions how to use UniObjects > with SSIS I would give that a try immediately. Since you asked: Contact me about mv.SSIS, which is a development component for SQL Server Integration Services. It's a super-set of mv.NET, and uses UniObjects _or_ UO.NET for transport with U2. This helps to avoid all of the problems documented in this thread. > Easiest would of course be to upgrade to UD 7.2 but > unfortunately I haven't been able to convince > management to approve that. Not required with any of the solutions provided above. > > From: "Brutzman, Bill" > > This problem resembles my recent problem with ODBC > > between HP-Ux and MS-SQL. Tech Support at Rocket > > indicated that I would probably have to buy special > > (ODBC) drivers from companies that specialize in data > > integration because... ODBC is a Microsoft thing and > > this sort of connectivity is not bundled with most > > (maybe any) flavors of Unix. > > > > Rocket agreed that using UniObjects would be an easier > > alternative. The approach which I've documented would be exactly the same for all of these problems. Approach the problem properly and you won't need to worry about the tools. HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula R&D sells mv.NET and other Pick/MultiValue products worldwide, and provides related development services remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
