data extraction from SAP r/3 to sql 2000, bpc server

[#1]

Hi All,

I have posted a similar thread previously,, and understood how to transfer data from SAP R/3 to SQL 2005, but I need to transfer data from SAP R/3 to SQL 2000 server, not SQL 2005 server.

Any help will be greatly appreciated.

Regards,

Kranthi.

[Former Member]

Kranthi,

Sql 2005 and sql 2000 have both the same possibilities. You can import data from an ascii file or directly from a sql table. An example package that does import data directly from an sql (staging) table is "import sql".

The only sitback is that if you have a package created in sql2005, that you have to recreate this in sql2000.

Alwin