question

Romensg avatar image
Romensg asked

SSIS dataflow task does not execute, no errors

I've created an SSIS package that contains a dataflow task. When I run the package, the previous 3 tasks complete successfully. Then, the package ends without attempting to execute the dataflow task. There are no errors, and it doesn't appear to try to run the dataflow (no validation of the task, no errors, nothing). There are no conditions other than "success" on the connector between tasks. I can right-click the dataflow and execute it separately, and it validates and executes. If I remove the connector between the third task and the dataflow, dataflow will execute. I've even tried recreating the package, adding tasks and running it. I got to the point where I had my three tasks plus the dataflow all connected and running. I added a task after the dataflow, and then the dataflow stopped executing.
ssis
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

nidheesh.r.pillai avatar image nidheesh.r.pillai commented ·
Have you introduced a breakpoint in the data flow task?
3 Likes 3 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.