Hi:

I am fairly familiar with SQL Server and DTS but not programming code-I
am doing research for a programmer. I imagine what we want to do is
fairly common so if if there are any articles out there you know of
that would be helpful:

1. We need some idea as to how to do the following through an install
(Installshield) script: a) create a database b) create proecedures in
that database and c) install a .dts package on the server

2. How to schedule a package through code using the SQL Server agent.
This would be done through a .NET front end.

3. How to set global variables in the DTS package through code.
Specifically, there would be a cleanup SQL Script in the package that
would delete old records. What constitutes an old record would be set
by the user in the front end.

I think there is some information in the Wrox DTS book for 2 and 3, but
I need to be armed with information as soon as possible.

Thanks,
Kayda

The toolkit you are looking for is called SQL-DMO. SQL-DMO is a heirarchy
of objects designed to control and configure a SQL server. BOL has
extensive documentation the entire object set (Index topic SQL-DMO). To
manipulate a DTS package through code, you use the Package object. It is
also fully documented in BOL. Both are installed with SQL server by
default.

Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator


<tabladude (AT) gmail (DOT) com> wrote