SHARE
Facebook X Pinterest WhatsApp

Open SSIS packages without validation using these SQL properties

Jun 2, 2008

[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

Recommended for you...

Best Certifications for Database Administrators
Ronnie Payne
Oct 14, 2022
Become More Efficient at Writing TSQL by Creating Code Snippets
Gregory Larsen
Jun 30, 2021
Line Numbers in SQL Server Management Studio
Gregory Larsen
Sep 4, 2018
Couchbase Raises $60 Million to Fuel NoSQL Database Efforts
Sean Kerner
Jun 30, 2014
Database Journal Logo

DatabaseJournal.com publishes relevant, up-to-date and pragmatic articles on the use of database hardware and management tools and serves as a forum for professional knowledge about proprietary, open source and cloud-based databases--foundational technology for all IT systems. We publish insightful articles about new products, best practices and trends; readers help each other out on various database questions and problems. Database management systems (DBMS) and database security processes are also key areas of focus at DatabaseJournal.com.

Property of TechnologyAdvice. © 2025 TechnologyAdvice. All Rights Reserved

Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.