Hello,
I'm evaluation SQL Server 2005 to use it as an ETL-tool. We need to connect
to a Progress v9.1C database as datasource. SQL Server 2005 operates on the
.NET platform, I'm not aible to connect to progress from the datasource tab
in the ETL-tool part of SQL Server 2005 (there is no ADO.NET or OLE-DB
connection availble). Could you please help me to solve this problem?
Greetings,
Paul Siteur
Vriendelijke groet,
Paulus
Paul Siteur
IBN-groep
ICT Applicatiebeheerder / Cognos ontwerper
Hockeyweg 5
5405 NC Uden
tel. 0413-33 44 37
e-mail psiteur@.ibn-groep.nl
www.ibn-groep.nlIf Progress has an ODBC client, install it on the machine you'll run
Integration services from (that's your development machine and the
deployment server) and use the OLEDB connection for ODBC as your data
source.
"plupos" <plupos@.discussions.microsoft.com> wrote in message
news:5E8E76FF-9DDA-477C-91C7-24FA782C07B4@.microsoft.com...
> Hello,
> I'm evaluation SQL Server 2005 to use it as an ETL-tool. We need to
> connect
> to a Progress v9.1C database as datasource. SQL Server 2005 operates on
> the
> .NET platform, I'm not aible to connect to progress from the datasource
> tab
> in the ETL-tool part of SQL Server 2005 (there is no ADO.NET or OLE-DB
> connection availble). Could you please help me to solve this problem?
> Greetings,
> Paul Siteur
>
> Vriendelijke groet,
> Paulus
> Paul Siteur
> IBN-groep
> ICT Applicatiebeheerder / Cognos ontwerper
> Hockeyweg 5
> 5405 NC Uden
> tel. 0413-33 44 37
> e-mail psiteur@.ibn-groep.nl
> www.ibn-groep.nl
Tuesday, March 20, 2012
Progress v9.1C database connection for SQL Server 2005 ETL-tool
Labels:
connection,
connectto,
database,
datasource,
etl-tool,
evaluation,
microsoft,
mysql,
oracle,
progress,
server,
sql,
v91c
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment