Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS [ad]

2010-01-14 Thread Mecki Foerthmann
Thanks Tony, but I think I will just wait until I've convinced management to approve the upgrade to 7.2 I know that release can talk to SSIS. We are talking hundreds of files here for that conversion and maybe thousands of Oracle tables, and I don't think I'm going to create classes for every

Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS [ad]

2010-01-14 Thread Symeon Breen
snip Tony Said Here's another common issue in this forum: People express a desire for a solution but what they really want is a free solution that they can use, understand, and maintain on their own. I'm sorry but when you're faced with complex issues, be prepared for solutions that you may not

Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS [ad]

2010-01-14 Thread Lettau, Jeff
, January 14, 2010 3:31 AM To: U2 Users List Subject: Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS [ad] Thanks Tony, but I think I will just wait until I've convinced management to approve the upgrade to 7.2 I know that release can talk to SSIS. We are talking hundreds of files

Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS [ad]

2010-01-14 Thread Gerd Forthmann
, 14 Jan 2010 08:43:06 -0500 Von: Lettau, Jeff jlet...@polkaudio.com An: U2 Users List u2-users@listserver.u2ug.org Betreff: Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS [ad] You may not want to do this due to volume of data your trying to pull, but... Have you tried setting

Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS

2010-01-13 Thread 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

Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS

2010-01-13 Thread Gerd Forthmann
, 13 Jan 2010 10:36:27 -0500 Von: Brutzman, Bill bi...@hkmetalcraft.com An: U2 Users List u2-users@listserver.u2ug.org Betreff: Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS This problem resembles my recent problem with ODBC between HP-Ux and MS-SQL. Tech Support at Rocket

Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS

2010-01-13 Thread jpb-u2ug
Sent: Wednesday, January 13, 2010 10:25 AM To: U2 Users List Subject: Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS Thanks Bill, 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

Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS [ad]

2010-01-13 Thread Tony Gravagno
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

Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS

2010-01-13 Thread Mecki Foerthmann
Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gerd Forthmann Sent: Wednesday, January 13, 2010 10:25 AM To: U2 Users List Subject: Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS Thanks

Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS [ad]

2010-01-13 Thread Mecki Foerthmann
Thanks Tony and Peter, but I don't think yet another piece of software is what I need. Your product might be useful for some of your clients, but I don't think it will help solve my problem. I don't want to update any MV files, just load some data into a relational database every night,

Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS [ad]

2010-01-13 Thread Tony Gravagno
From: Mecki Foerthmann Thanks Tony and Peter, but I don't think yet another piece of software is what I need. Your product might be useful for some of your clients, but I don't think it will help solve my problem. That's funny. I don't have an application and there is no real way