Progress to Sqlserver - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Progress to Sqlserver

Author

Topic

Ranjeeta
Starting Member

1 Post

Posted - 2010-05-13 : 02:27:00

Hi,

I am using SSIS to transfer a Database from progress to Sql server.

I am using OpenEdge 10.1B ODBC driver to connect to progress.

Here Progress is Source and a Sqlserver is the destination

I have created a Linked server from my Destination Sqlserver to the Progress Database.

Now how can i Transfer the whole Progress Database to Sql server using SSIS.

Can i user Transfer Database Task to import Progress DB to SQL Server.

Please let me know how i can use the Linked server as my source ??

Regards
Ranjeeta

SQLviper
Starting Member

1 Post

Posted - 2010-05-17 : 08:47:59

Ranjeeta,

I have previously used a 4 part identifier to access linked server data.
[Linkedserver].[Database].[Schema].[Table], or you can use OpenRecordSet or OpenRowSet ( See SQL Server help )

I am trying to set up a Linked Server from Progress 10.1B to SQL Server . Could you please share the script on how to create the Linked Server? My attempts so far have failed. Any help would be greatly appreciated.

Regards,
SQLViper aka devinport@gmail.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources