Automating DTS conversion?

I am down to data conversion on the new project. I've got a bunch of
ProvideX ODBC tables that I need to convert to SQL Server 7.0 tables for the
new program. I can import them into the new database in SQL's Enterprise
manager using the Table Import wizard, but I want to automate this process
in the new program.

So, is there a way in Delphi to automate the DTS Import Wizard that comes
with Enterprise Manager?

If so, some sample code or a link to a website with examples would be
wonderful.

Thanks in advance.

john


.

Relevant Pages

  • Re: Importing Excel data with "/" chars
    ... Jochen.Markert@xxxxxxx skrev: ... I used the import wizard in Enterprise Manager (in MS SQL Server 2003). ...
    (microsoft.public.sqlserver)
  • Re: Anaylze TSD in Excel wizard automation
    ... I think you are on the right track to writing VBA code. ... on how to get the timescaled data directly out of the database with queries. ... Data in Excel" wizard to output worksheets for 10 different groups of ... > I'd like to be able to automate that. ...
    (microsoft.public.project)
  • Re: Refresh after import SS2K
    ... The problem is that after I import a table using the Import Wizard, ... > have to shut down your SQL Server Enterprise Manager when you running DTS ... Is there any error messages in Event Log or Error ...
    (microsoft.public.sqlserver.server)
  • Re: Help with importing...
    ... VBA procedure, run from a Command button's OnClick event. ... if you're manually running the Import Wizard on the .csv file each ... same sequence in a macro or VBA procedure. ... > would it be possible to automate that process? ...
    (microsoft.public.access.externaldata)
  • Re: Automating Excel Data Import
    ... them to the database as linked tables. ... databse. ... It requires me to go through the import wizard 6 times to import all ... Is there a simple way to automate this?? ...
    (microsoft.public.access.externaldata)