SSIS Dataflow task not starting for long time

Question

0.00/5 (No votes)

See more:

I have a dataflow task which going to pull the records from Server B table and load it in Server A table. I'm using OLEDB source and OLEDB destination transformations. the OLEDB source is sql query that depends on variable (table name will be changed at the runtime in the from clause). the source sql query getting around 500 to 1500 rows.

the package is deployed in Server A,
the package runs very good for a past six months,
now the package and Data Flow task is started and showing progress info, but in the OLEDB source transformation its in ideal not showing progress info also.

but, when the source query run from the SSMS in the server A its finished rendering records in 15 seconds, but the package takes long time more than 30 min and its in ideal not showing progress info.

kindly guide me to fix it, thanks in advance...

Posted 20-Aug-15 19:15pm

Member 10108172

Updated 3-May-16 21:28pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2015-08-20T19:21:00

Solution 1

This sounds like the query you use to get data is not performing very well.

If the source is an SQL Server database, probably the best way to find out what takes time is to use SQL Server Profiler[^]. Profile the incoming calls from the source server side and see if the query is the bottleneck.

Posted 20-Aug-15 19:21pm

Wendelius

Comments

Member 10108172 14-Oct-15 3:16am

Mika thanks for the response, the sql query is just a select statement with date filter and query is executing in ssms within 15 sec, but no response in the ssis package.