sql server dts: Scheduling non-SQL Server job after DTS completes -- sql server dts

Scheduling non-SQL Server job after DTS completes

Mike Austin
11/29/2005 12:20:02 PM

sql server dts: 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,

Re: Scheduling non-SQL Server job after DTS completes

Allan Mitchell
11/29/2005 9:21:17 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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.