How to call a SQL Server DTS package

RazorSQL cannot execute DTS packages directly. However, RazorSQL can execute stored procedures. If a stored procedure is created to call the DTS package, then RazorSQL can call the stored procedure, which will then execute the DTS package.

For example, SQL Server has an available stored procedure called sp_start_job. If the DTS package is setup as a job, then RazorSQL can be used to execute the DTS package by calling the sp_start_job procedure.