Solved

dataflow failing for more load

Posted on 2009-05-14
8
404 Views
Last Modified: 2013-11-10
i have a dataflow task in all the   6 child packages ,they are executed well when subset of my full feed is given as input, but when i am trying to execute for full feed all are failing with the error  '[Connection manager "SQL Server"] Error: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available.  Source: "Microsoft OLE DB Provider for SQL Server"  Hresult: 0x80004005  Description: "Timeout expired". ....any suggessions please..
0
Comment
Question by:ametuer999
  • 4
  • 4
8 Comments
 
LVL 30

Expert Comment

by:nmcdermaid
ID: 24405722
'Timeout Expired' means something tool too long so it gave up.
So you need to find out what the bit was that took too long.
Try these things:
1. Run the sub package under full load by itself (not called from the parent). Does it time out?
2. Add logging to the sub package to see if it can give you a clearer message
0
 

Author Comment

by:ametuer999
ID: 24409090
i will try and let you know
0
 
LVL 30

Accepted Solution

by:
nmcdermaid earned 500 total points
ID: 24410299
If you can narrow a subpackage down to a select statement, try running that statement in Management Studio and see if it times out. It could be that its just taking too long to retrieve your data, in which case you'll need to extend a timeout or optimise the query.
0
 

Author Comment

by:ametuer999
ID: 24428662
SORRY FOR THE DELAYED REPLY..i was a little busy with some other work..could you please explain me more about logging..i never tried it..my child packages are loading files into tables..could you please look into my another open question DATA FLOW TASK ..please look into the package attached there and suggest me some solution..thank you
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 30

Expert Comment

by:nmcdermaid
ID: 24437303
Logging is an option that you turn on in SSIS. But its probably quicker if you run your sub package directly (in BIDS) with a full load and view the log that it generates.
... I already commented in your other thread a few days ago. It looks like you have a DTS > SSIS upgrade going on and you are trying to recreate DTS functionality in SSIS. This is not a good idea.
 
 
0
 

Author Comment

by:ametuer999
ID: 24438157
But i could not figure out a solution to replace dynamic column mapping that is being used in my legacy DTS pakage..could you please suggest me some possible solutions..please.this is almost my last hurdle in my project...and  i have one more question..though i gave EXCELLENT for my Import Engine solution how could it be 7.7...Thanks you
0
 
LVL 30

Expert Comment

by:nmcdermaid
ID: 24446791
You'll need to comment that in your other question - it gets very confusing when you comment accross questions.
As far as we can see in the other question, you were going to get back to us. I will now comment in the other question!! :)
0
 

Author Comment

by:ametuer999
ID: 24453181
ok...thanks
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now