dtexec Utility (SSIS Tool)

You can run dtsx (SSIS Package) files in powershell using this tool. EXEC xp_cmdshell ‘dtexec /f “C:\DATA\EligibilityCategory.dtsx”‘ The following example shows how to run the same package and capture the return code: DECLARE @returncode int EXEC @returncode = xp_cmdshell ‘dtexec /f “C:\DATA\EligibilityCategory.dtsx”‘ Following values will be returned;