Mayank Tripathi
asked on
SSIS package is taking too long time to load when i open. Is there any configuration to stop this validations?
SSIS package is taking too long time to load when i open. Is there any configuration to stop this validations?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Set DelayValidation to TRUE / ValidateExternalMetadata to FALSE in every component in the package. What is happening to you is SSIS has to validate that every connection and data flow to whatever matches with its data source before allowing the developer to edit the package.
ASKER