I am trying to automate the set up of my database on customer machines. Some will need a DTS package to be created and scheduled. Can this be done strictly with T-SQL to avoid having to do it through code or wizards?

There is not a way to create a DTS package via TSQL, unless you can create
an application to create one and then call teh application from TSQL using
the xp_cmdshell procedure.

Rand
This posting is provided "as is" with no warranties and confers no rights.