Alternative to DTS wizard
-
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
-
I think you'll run into licensing issues by distributing the necessary DTS runtime files with your MSDE install anyway.
As for the MSDE management GUI, there are quite a few out there. Do a quick google search and then take your pick.
--------------------
Colt 45 - the original point and click interface
-
Phill,
MSDE can run DTS jobs fine from a licensing perspective. It just lacks a DTS creation utility. It's this utility which I'm looking for.
cheers
Danster
-
Danster,
Sorry can't shed any light on the DTS creation utilities, however the cheapest way is probably to buy a licensed version of SQL Server 2000 Developer edition which obviously includes the admin tools (Enterprise Manager and Query Analyser), developer has the same functionality as SQL Server Enterprise edition but is restricted from a licensing point of view for development and testing only. Obviously if you have a full version of SQL Server installed with client tools on your particular network then you can simple register your MSDE instance and use the tools you already have.
As for the GUI to manage MSDE, try this http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en requires the .NET framework and allows you to create/administer databases, logins, users etc.
ll
-
The reason I raise this is because I did some work for a client that had a DTS solution involving just Excel spreadsheets and no SQL server. MS told them they could only distribute and use DTS in conjunction with a properly licensed SQL Server. If they kept their solution in house (where they did have a SQL Server) there was no problem.
--------------------
Colt 45 - the original point and click interface
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply