December 22, 2014 at 3:00 am
I have 2 seperate tasks, one is automated currently through SSIS (data imports) and the other is manual (executing SP's) due to the list of SP's changing.
So we can automate this, but stay flexible, I am creating a second package which will just have 1 execute SQL task to run the SPs. I will put this package on a share for developers to access it and change the task as required.
This Package will be started by a SQL job, and the SQL job will be executed as the last step of the first SSIS package.
If the job and second SSIS package fails, will this fail the 1st SSIS package? Or will the 1st one succeed as the job has been started?
December 22, 2014 at 3:43 am
SQLAssAS (12/22/2014)
I have 2 seperate tasks, one is automated currently through SSIS (data imports) and the other is manual (executing SP's) due to the list of SP's changing.So we can automate this, but stay flexible, I am creating a second package which will just have 1 execute SQL task to run the SPs. I will put this package on a share for developers to access it and change the task as required.
This Package will be started by a SQL job, and the SQL job will be executed as the last step of the first SSIS package.
If the job and second SSIS package fails, will this fail the 1st SSIS package? Or will the 1st one succeed as the job has been started?
The last one.
sp_start_job is asynchronous and doesn't wait for the result of the job.
It just returns if it could start the job or not.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 22, 2014 at 4:52 am
perfect - cheers
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply