Starting a SSIS 2012 DTSX package without validating it?
-
Hello, Is it possible to start a SSIS 2012 DTSX-package via DTEXEC.exe (classic method in command shell) or Integration Services Catalogs (SQL Server 2012) without validating it? I have several very big packages and the validations take several minutes causing performance problems because I have to run the packages every XX minutes and the validations take too much time. I read the documentation of DTEXEC.exe and found a parameter that can be used in order to validate a package without executing it, but I need the opposite thing: just execute without validate it! Thanks for any advices! Best wishes, Miroslav
-
Hello, Is it possible to start a SSIS 2012 DTSX-package via DTEXEC.exe (classic method in command shell) or Integration Services Catalogs (SQL Server 2012) without validating it? I have several very big packages and the validations take several minutes causing performance problems because I have to run the packages every XX minutes and the validations take too much time. I read the documentation of DTEXEC.exe and found a parameter that can be used in order to validate a package without executing it, but I need the opposite thing: just execute without validate it! Thanks for any advices! Best wishes, Miroslav
Instead of running it every XX minutes - why not keep it running all day - just sleep the task between runs. http://microsoft-ssis.blogspot.com/2011/04/pause-in-ssis.html[^]