Open SSIS packages without validation using these SQL properties

Monday Jun 2nd 2008 by DatabaseJournal.com Staff

SQL Server expert Robert Sheldon explains how to use the DelayValidation and ValidateExternalMetadata properties for delaying validation in your SSIS package.

[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

Mobile Site | Full Site