January 11, 2012 at 11:19 am
I am wondering if it is possible to call SSIS objects from stored procedure. I can call dtsx file from stored procedure but like to call objects inside the dtsx file from stored procedure..
fox example.. lets say there are so many object in dtsx file like Execute SQL Task or Data Flow Task. I wanted to call only particular Execute SQL Task or Data Flow Task in dtsx file.
The reason I am doing this because there are lots of Task in the dtsx file and sometime it gets failed so I wanted to run only the failed task instead of running the whole dtsx file.
Any help will be appreciated
January 11, 2012 at 11:59 am
balbirsinghsodhi (1/11/2012)
I am wondering if it is possible to call SSIS objects from stored procedure. I can call dtsx file from stored procedure but like to call objects inside the dtsx file from stored procedure..fox example.. lets say there are so many object in dtsx file like Execute SQL Task or Data Flow Task. I wanted to call only particular Execute SQL Task or Data Flow Task in dtsx file.
The reason I am doing this because there are lots of Task in the dtsx file and sometime it gets failed so I wanted to run only the failed task instead of running the whole dtsx file.
Any help will be appreciated
Not as far as I know...and if there is a way it would be very cumbersome to extract the relevant xml from the source package and create a "temporary" package to execute.
I would suggest that you look at checkpoints, which allow you to "restart" an SSIS package from the point of failure.
January 11, 2012 at 9:54 pm
Execution of a package from SQL is already painful so this is even more complex.
You can probably disable some components by changing parameters on the command line. But I would probably wrap individual sections in containers and then disable or enable those containers.
CEWII
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply