I have a DTS/ETL package that is running perfectly. The data from the data
marts is currently imported into SAS/SPSS for cleaning and weighting. The
SAS/SPSS jobs are kicked off manually. I want to be able to schedule these
SAS/SPSS jobs so that they automatically execute after the DTS package
sucessfully completes.

Any help welcome.

TIA,

Mike

I know nothing about SAS/SPSS but would offer the following

How do you kist them off now?

If it is a command line interface then call that through a job step
after your DTS package or within the package itself.
Can you set a flag somewhere and have the SAS/SPSS job look for the flag
before executing?
Can you make a call into an interface programmatically to kick off the
job?


Allan

"Mike Austin" <MikeAustin (AT) discussions (DOT) microsoft.com> wrote