C++ wrapper for DTS objects (Package2)

  • Hi,

    Does anybody know where can I get the C++ wrapper for accessing DTSs, i.e. the implementation of Package, Package2 etc. objects, or how can I construct it?

    Thanks a lot,

    Ilan

  • Not being a C++ developer (nor do I even play one on TV), I don't know exactly what is available for C++, but I can point you to a couple of resources that may help your quest. 

    if you installed the Developer Tools during SQL Server setup, there are a lot of C header files and samples in the \Program Files\Microsoft SQL Server\80\Tools\DevTools directory.

    As far as accessing the Package, Package2, etc objects, those are ActiveX/COM objects available for any language.  Search in BOL for SQL-DMO and the entire object library and coding samples are there for this powerful interface. 

    I would suggest using the SQL-DMO route, as that gives you everything you need to interface with SQL Server, works with different versions, and is how Enterprise Manager works.

    Hope this helps



    Mark

  • Thanks a lot, I'll try following that lead.

    Ilan

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply