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
Solved

dataflow failing for more load

Posted on 2009-05-14
8
422 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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.
Viewers will learn how the fundamental information of how to create a table.

809 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