• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 459
  • Last Modified:

dataflow failing for more load

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
ametuer999
Asked:
ametuer999
  • 4
  • 4
1 Solution
 
nmcdermaidCommented:
'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
 
ametuer999Author Commented:
i will try and let you know
0
 
nmcdermaidCommented:
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
ametuer999Author Commented:
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
 
nmcdermaidCommented:
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
 
ametuer999Author Commented:
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
 
nmcdermaidCommented:
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
 
ametuer999Author Commented:
ok...thanks
0

Featured Post

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!

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now