Let say you need to run scheduled DTS package on Microsoft SQL 2005 Express and
as you probably know there is no SSIS and Agent Services in Microsoft SQL 2005 Express
edition but you can do this job actually very easy :
Assure that you do have the DTExec util, it should be in
C:\Program Files\Microsoft SQL Server\90\DTS\Binn folder ,
if you do not have one means you should install SQL Toolkit .
Next step is to make a batch file to run the DTS package.
Create batch file with DTExec formatted command for example
The example above shows how to run DTSX Package from File and Log
the results of execution to some log file.
Last step is schedule and Yes there is one in Windows it called " Scheduled
Tasks" you could find it in System Tools – just create one with call of the batch
that you created earlier to run dtsx packages.
And that's all you need for the job to be done ;)...