MS SQL Server DTS - Scheduling non-SQL Server job after DTS completes

Author

Scheduling non-SQL Server job after DTS completes

Mike Austin

2005-11-29, 8:24 pm

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

Allan Mitchell

2005-11-29, 8:24 pm

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@discussio
ns.microsoft.com> wrote in message
news:6024E147-CDBB-431F-B235- 0848C2606A58@microso
ft.com:

> 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

Sponsored Links