ssis package taking ages to open

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » ssis package taking ages to open

ssis package taking ages to open

Rate Topic

Display Mode

Topic Options

Author

Message

erics44

Posted Monday, November 05, 2012 4:13 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, May 20, 2013 7:27 AM
Points: 266, Visits: 512

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

Post #1380969

Stewart "Arturius" Campbell

Posted Monday, November 05, 2012 4:26 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 8:31 AM
Points: 3,129, Visits: 4,312

Check the "Delay Validation" property in the package and it's various components

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Post #1380972

Jason-299789

Posted Monday, November 05, 2012 4:27 AM

SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 1:30 AM
Points: 803, Visits: 2,124

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

Post #1380975

Koen Verbeeck

Posted Monday, November 05, 2012 4:51 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:11 AM
Points: 9,378, Visits: 6,473

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.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1380987

Unsy

Posted Tuesday, November 06, 2012 3:46 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 12:55 PM
Points: 152, Visits: 311

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. BigGrin

Unsy

Post #1381737

« Prev Topic | Next Topic »

Permissions