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

[Former Member]

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 · Accepted solution]

In SQL you will use Integration Services (SSIS) as the ETL tool and in SQL 2000 you will need to use DTS. The principles are still te same; you exactract data from the source system to a comma seperated file and when this is done you use the 2 SAP BPC steps in the DTS to load the datafile. These steps are Convert and Load & Process.

-Joost

[Former Member · Accepted solution]

HI Joost,

So,I need to have a comma seperated file in between and can not load directly to sql server as I can do it in SQL 2005?

is my understanding correct or is there any other way to directly load data to SQL 2000?