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

2010-01-14 Thread Gerd Forthmann
tum: Thu, 14 Jan 2010 08:43:06 -0500 > Von: "Lettau, Jeff" > An: U2 Users List > 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 s

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

2010-01-14 Thread Lettau, Jeff
hmann Sent: Thursday, 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

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

2010-01-14 Thread Symeon Breen
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 unde

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 attr

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 rea

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, preferably

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

2010-01-13 Thread Mecki Foerthmann
UD 7.2 but unfortunately I haven't > been able to convince management to approve that. > > Mecki > Original-Nachricht > >> Datum: Wed, 13 Jan 2010 10:36:27 -0500 >> Von: "Brutzman, Bill" >> An: "U2 Users List" >> Betr

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 tha

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

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

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

2010-01-13 Thread Gerd Forthmann
--- > Datum: Wed, 13 Jan 2010 10:36:27 -0500 > Von: "Brutzman, Bill" > An: "U2 Users List" > 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. T

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

2010-01-13 Thread Brutzman, Bill
, 2010 7:39 AM To: U2 Users List Subject: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS Hi I am trying to use SSIS to load UniData tables to SQL Server 2008. I already have been using DTS with SQL Server 2000 successfully for a while and I set up everything (System DSN and UCI Editor) the

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

2010-01-13 Thread Mecki Foerthmann
Hi I am trying to use SSIS to load UniData tables to SQL Server 2008. I already have been using DTS with SQL Server 2000 successfully for a while and I set up everything (System DSN and UCI Editor) the same on the 2008 server. The connection test works fine, but when I try to go further I get this