November 12, 2014 at 9:57 am
I have a SSIS package that I am running from a SQL Agent job. I have to run a msdb Stored procedure first and then run the package. So I have created 2 steps. step-1, type =Tra-SQL where I am running my Stored Procedure. And then step-2, type= Integration Services which is running the package. I am attaching a config file here too. Is there a simple way to do these 2 steps in just 1 single step without too much complexities.
In the step-1 , SQl command=EXEC MySQlProcedure
In the step-2 , by default the commandline=/SQL "MyPackage" /SERVER MySqlSer /CONFIGFILE "MyDataConfig.dtsConfig" /CHECKPOINTING OFF /REPORTING E
Thanks.
February 10, 2015 at 8:04 pm
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply