Home Forums SQL Server 7,2000 SQL Server Agent SQL Agent Job need just 1 step RE: SQL Agent Job need just 1 step
HawkeyeDB
SSC Enthusiast
Points: 161
More actions
February 10, 2015 at 8:04 pm
#1776811
Why does it matter that you have two steps?
One possible solution would be to modify your SSIS package to include the execution of the stored procedure eliminating the need for your step 1. It would be an Execute SQL task.