This is all about running SSIS Web packages;
DTExec /ISSERVER “\SSISDB\fm\fmimports\ALL_STG_Main_Run.dtsx” /SERVER “172.16.20.13” /Envreference 3
Resources
https://stevestedman.com/2016/05/is-enabling-xp_cmdshell-a-security-risk/
this link is helpful
https://www.timmitchell.net/post/2016/11/28/a-better-way-to-execute-ssis-packages-with-t-sql/
How to script out packages
http://tomaslind.net/2015/12/07/ssisdb-catalog-create_execution/
ErrorDescription
Error 0xC0012050 while executing package from project reference package “STG_SETO_MilestonesImport.dtsx”. Package failed validation from the ExecutePackage task. The package cannot run. .
Add to favorites
