few Days back i posted about SSIS package . as per our discussion with our architect we have decided to to go with SSIS package.
when developing a small application with SSIS i noticed if we have multiple Tasks coming from single TASK then all those execute in parallel and if i am not wrong that is parallel processing in SSIS package by default.
The task which has many connecting lines coming to it waits for all tasks to finish their execution.
When those tasks are executing in parallel in SSIS package if any of task fail the we can have seprate exception handling for that particular task.
so i guess we have parallel processing of task by default in SSIS package .
Please let me know you suggestions .
No comments:
Post a Comment