I'd like to validate and then execute SSIS package stored in SSIS Catalog (Project Deployment Model) via objects from Microsoft.SqlServer.Management.IntegrationServices
namespace.
When I execute Validate method from PackageInfo class it only runs validation, but no wait till its end. In one example I've found author fires validation in 'fire and forget' mode - why fire it when we don't bother with result? In another one execution is fired without previous validation.
catalog.validations status
column and can have, inter
alia, values succeeded (7)
and completed (9)
- what is
difference between them?Ad 2: I was able to wait for validation result in a loop:
var validationId = package.Validate(false, PackageInfo.ReferenceUsage.UseAllReferences, null);
ValidationOperation validation = package.Parent.Parent.Parent.Validations[validationId];
do
{
Thread.Sleep(1000);
validation.Refresh();
}
while (!validation.Completed);
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With