Re: Automating DTS conversion?

My simple understanding of DTS is that it is its own API with a convenient
COM interface. I've written regular C++ code that's invoked the API to
bulk load a database.

I started by using the Import/Export wizard and having it generated a VB
file with the DTS driving code. I then translated that into C++.

I would expect that you can import the DTS library using the ActiveX Type
Library import Delphi feature.

Chris, thank you for the direction. Since I've only ever used DTS via the
Microsoft Enterprise manager interface, what should I look for? I've never
imported an ActiveX Type Library into Delphi before so you have to go slow.
<smile>

I'm going to see if I can get it to generate that VB code you mentioned .
I'll also try Googling for something along these lines too.

If you or anyone has a better example, please share!

Thanks again Chris!

john


.

Relevant Pages

  • Re: Automating DTS conversion?
    ... I started by using the Import/Export wizard and having it generated a VB ... I would expect that you can import the DTS library using the ActiveX Type ... Microsoft Enterprise manager interface, ... pkg: OleVariant; ...
    (borland.public.delphi.database.ado)
  • Re: DTS with SQL Express 2005
    ... Allan ... there is no mention of Import/Export in the express "Books online" ... > Based on DTS in what way? ... > Whilst it does the same job as the old DTS Import/Export wizard I would ...
    (microsoft.public.sqlserver.dts)
  • Re: Automating DTS conversion?
    ... My simple understanding of DTS is that it is its own API with a convenient ... COM interface. ... I've written regular C++ code that's invoked the API to ...
    (borland.public.delphi.database.ado)
  • Re: Is it possible to export a View to Excel in MS SQL 2000 ?
    ... If this is a one-off task, the Import/Export Wizard can export to a ... ..xls. ... If you need to run it regularly, then you can save the DTS ... Prev by Date: ...
    (comp.databases.ms-sqlserver)