Alternative to DTS wizard?

[Danster]

Gday,

I install MSDE at many clients of mine.

As part of the database I'm creating, it is essential that I get data from another database (non-SQL, but a ODBC DSN exists to get it).

Ideally I use the DTS Import/Export wizard which is excellent. Then I need to schedule the DTS package for a regular update.

Problem is, is that to get it I need to install the SQL Server client tools. Becuase I'm not supposed to install the SQL Client Tools to get a nice GUI to manage the MSDE installation, I really shouldn't be using the DTS wizard.

I'm looking for a (ideally free) utility that can create a DTS package just like the DTS wizard. I can then use the DTSRUN command to schedule it in a batch file. Oh, and a nice GUI to manage MSDE would be good too (ideally free also).

Cheers

Danster

 

[Catadmin]

Sorry, don't know of one. Tried to do a Google, but only spotted Microsoft references in the first page.

The only alternative is using the DTS Package Designer, but that's in Enterprise Manager which wouldn't obviate your need to install the SQL Client Tools.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???