Hi, I need to check an old SSIS installation that seems corrupt. Does exist a list to report the files necessary to run dtexec, detexecui, etc.? Many thanks

Hi pscorca, If you are unsure whether the SSIS is functioning please provide with symptoms of what is not working as expected. In many cases, however, it is possible to repair the installation. To do so you need to obtain the installation media matching the SSIS version and build installed. Once the media is available run the repair process for the SQL Server (you may wish to repair more than just shared services, I recommend repairing all what is installed), the procedure is best described here: http://msdn.microsoft.com/en-us/library/cc646006.aspx As to what it comes to having a list of items that came with SSIS I am skeptical you will be able to get it, yet I see little value in it because SSIS relies on many other items that is not part of it but they could make it broken if amiss. Besides, dtexec and detexecui are standalone executables for running SSIS packages, dtexec is quite a critical command line tool, and anyone can delete it, but such an activity is more like a sabotage to me than a corrupted SSIS install. Arthur My Blog

Hi pscorca, If you are unsure whether the SSIS is functioning please provide with symptoms of what is not working as expected. In many cases, however, it is possible to repair the installation. To do so you need to obtain the installation media matching the SSIS version and build installed. Once the media is available run the repair process for the SQL Server (you may wish to repair more than just shared services, I recommend repairing all what is installed), the procedure is best described here: http://msdn.microsoft.com/en-us/library/cc646006.aspx As to what it comes to having a list of items that came with SSIS I am skeptical you will be able to get it, yet I see little value in it because SSIS relies on many other items that is not part of it but they could make it broken if amiss. Besides, dtexec and detexecui are standalone executables for running SSIS packages, dtexec is quite a critical command line tool, and anyone can delete it, but such an activity is more like a sabotage to me than a corrupted SSIS install. Arthur My Blog