I have a couple of DTS which I want them to run one after another and at the end I want to run a VBS.
How can I Run a DTS from the SQL Server Agent? my Goal is put the Execute command for each DTS in differernt Agen steps.
Thanks

There is a dtsrun utility that you can use to run a DTS package from SQL Server. Check it out in books online.

Hi,
Create a stored procedure and put this line after AS,
exec master..xp_cmdshell 'dtsrun /S YourServerName /N YourDTSPackageName /E '

'/U' '/S' must be used instead of E for Username and password credentials instead of trusted connection '/E'

YOu can ruan as amany packages as you want.
Corvin