Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

dataflow failing for more load

Posted on 2009-05-14
8
Medium Priority
?
457 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 2000 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

963 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