Disabling SSIS Package Validation when Loading a Package in the VS Designer
I have a few SSIS packages that are deployed to a SQL 2005 Server and are subsequently designed and maintained in Visual Studio 2003. When I open any of the BIDS projects, followed by one of the packages, the designer always validates every Data Flow and Task object.
Usually, this isn't a problem. However, under certain circumstances a system account that we use for connecting and export data from an AS400 will not validate properly. Since I'm exporting a TON of tables, each Data Flow object attempts to connect to the AS400 through an ODBC connection, it gets an "Invalid Account" error, and then proceeds to attempt validation of the next task. This locks the system account because the invalid credentials are tried 40+ times.
Is there something that I can do to disable validation until I try to run the package? As an alternative, is there a setting I can toggle that will stop all validation as soon one invalid object is found? The AS400 system will allow a few mistaken attempts before locking the account. Obviously, it would be optimal if I could cut off the validation process before that takes place.
What options do I have?
Answer
Sorry to be vague, but this is too long to copy/paste
"SSIS package taking forever to load when you open it?"
This describes these 3 options which affect loading speed + the validation
- DelayValidation property
- ValidateExternalMetadata property
- “Work Offine” option (SSIS menu -> Work Offline to enable/disable it)
You can also "DelayValidation" to in several other places too per connection/task