Data Flow Task Start up Issue

Question

We have a SSIS package. In that we have a Data Flow Task. It is working fine but at the time of execution, Data Flow Task taking much time(10 min) to start the records flow. Why that is taking that much time to start up the records flow. Give me some suggestions. Is that delay validations issue?

Answer 1

It depends. It can be validation, it can be a slow source.
Without the details of the package and the results in the progress window, all we can do is guess.

---

MCTS, MCITP - Please mark posts as answered where appropriate.

Answer 2

The delay validation property for that package is true.

Answer 3

The delay validation property for that package is true.

I repeat:

Without the details of the package and the results in the progress window, all we can do is guess.

---

MCTS, MCITP - Please mark posts as answered where appropriate.

Answer 4

Please provide more info about your data flow and the log. In the log you can see what part is taking so long (validation or caching lookups, etc.). And your data flow could also just be slow because used some Semi-blocking or Fully-blocking components that worsen the execution time or you did not follow the best practices that worsen the performance. Plenty of possibilities

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 5

The two most common causes of delays in "starting" a Data Flow Task in my experience are:

• Fully cached lookups
• Sources that take a long time to return the first buffer's worth of rows (approx 10K)

---

Talk to me now on

Answer 6

Hello,

Please provide some more information on your data flow task. We cannot guess the actual issue from the information.

Answer 7

what about the source query. how much time your source query is taking to execute. if it's taking too much to execute then you need to optimize your query which should resolve your problem.

thanks,

zaim Raza.