November 5, 2012 at 4:13 am
Hi
An ssis package i have been working on has started to take ages to open. It also takes ages to start.
It didnt used to do that, i dont know if ive changed some setting or something.
It seemed to be validating and then now it doesnt even seem to be doing that, its just hanging for a while before i can work on it.
Anyone any ideas what i might have done?
thanks in advance
November 5, 2012 at 4:26 am
This was removed by the editor as SPAM
November 5, 2012 at 4:27 am
If it is validating it has to validate every connection that you have as well as the metadata, not knowing the number of data pumps source connections will not help.
You could try setting the DelayValidation to True on the properties of the tasks, this can be dangerous, as you may not see any possible errors until you run the process.
_________________________________________________________________________
SSC Guide to Posting and Best Practices
November 5, 2012 at 4:51 am
Validation can take a long time if some connections are slow or do not respond at all.
If a connection cannot be made, the validation process waits for a time-out.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 6, 2012 at 3:46 pm
The easiest way to speed up opening an SSIS Package & to avoid validation is to check the "Work Offline" option in the SSIS Menu in Visual Studio.
http://msdn.microsoft.com/en-us/library/ms137625.aspx
This can remove those painful waits from now on. 😀
Unsy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply