Open SSIS packages without validation using these SQL properties

[From Search SQL Server]

When you open a SQL Server Integration Services (SSIS) package in SSIS Designer or add components to a package, SSIS by default checks the data sources used by the various components. This process for SSIS package validation ensures that the external metadata is valid. If the metadata is not valid, you’ll receive warning or error messages pointing to the problem. At times, you might want to override the default behavior and open the SSIS package without validation. SSIS supports two properties — DelayValidation and ValidateExternalMetadata – that let you control the validation process on individual components.

The article continues at

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1315177,00.html

Get the Free Newsletter!

Subscribe to Cloud Insider for top news, trends & analysis

Latest Articles