December 17, 2013 at 3:28 pm
I have a package in BIDS that takes a very long time to load (about 30 min). During that time, it is validating this and that. The worst part is validating an OLE DB connector in the Data Flow task. The Connector accesses a view that returns aggregated data from a large source table.
It appears that BIDS (Visual Studio, that is) runs the query before giving me control. If that is true, it is NOT GOOD, since the query is correct and does indeed run a while, depending on server load.
I actually have three long wait times:
1. Initial package validation -- query runs during DFT validation
2. Opening the DFT tab -- query apparently runs a second time
3. Opening the OLE DB source component -- query is run a third time, or so it seems.
4. Then, once I close the OLE DB connector, it apparently runs the query again, just to be sure!
Questions:
1. Are my observations correct?
2. Does VS actually run the long-running query four times as I suppose?
3. Can anything be done about this?
4. Is there a configuration option I missed to tell VS to bypass validation until I'm good and ready?
December 18, 2013 at 12:24 am
Try setting DelayValidation to true on the package and the data flow.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply