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 2000 Forums
 Import/Export (DTS) and Replication (2000)
 General DTS question

Author  Topic 

Soulfly73
Starting Member

1 Post

Posted - 2008-01-24 : 15:21:04
Hello All,

I'm quiet new in this, so I just had an general question about configuring DTS packages.
Is there an standard way to build an package with an connection to an SAP database? Any info would be appreciated,

Thanks,

Peter

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2008-01-24 : 17:29:36
sure. you just need to use the proper odbc/OLE DB library to connect tothe backend SAP database.

keep in mind that you will be querying the underlying tables, not using the built in SAP tcodes. So, this could be a lot trickier than you may think at first since the SAP schema is pretty cryptic.

also, any work that you do behind the scenes will not be seen by your SAP basis admins, so if you cause performance issues they will not be aware of what you are doing and may have problems with that.



-ec
Go to Top of Page
   

- Advertisement -