Solved

dataflow failing for more load

Posted on 2009-05-14
8
426 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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
 
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql query help 15 51
How come this XML node is not read? 3 27
SQL Distinct Question 3 13
SQL Server Compression Decision 5 42
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how the fundamental information of how to create a table.

756 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