April 24, 2012 at 10:38 pm
How to run sql server agent job by using ssis package, means which ssis task have to use.
April 25, 2012 at 12:08 am
Question a bit confusing, but here's a stab...
SSIS is for your dtsx packages, hosted in a SQL Agent Job Task to run on a schedule/once off.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 25, 2012 at 1:36 am
You can start a SQL Agent job in SSIS by using the sp_start_job stored procedure in an Execute SQL Task.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 25, 2012 at 6:28 am
Thank you i will try these ways...
kishore.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply