The problem of calling DTS package in the job

How to call the DTS package in a job

Problem 1:
How to use Job Scheduling DTS package

Method:
1. Enterprise Manager -- Data Conversion service -- local package -- Right-click the package you want to schedule -- select "scheduling package" -- set the scheduling schedule.
2. If you create a job directly, select "cmdexec" in the job's step type. In the job's code, use dtsrun to execute the specified DTS package.

Problem 2:
In a job, you can query the status of a record in the database table. If the status matches, you can execute the next step of the job and call DTS to execute the job. How can this problem be solved?

Method:
Change the job type to tsql, and then use the job code similar to the following:
If exists (select * from...) -- Data Retrieval
Exec master... xp_mongoshell 'dtsrun... '-- if it succeeds, call xp_mongoshell to call the dtsrun tool execution package.

Original post address