• SpeedSkater is describing what I consider to be a bug in MSSQL. If you have installed SQL Express, you cannot install SSIS on the same machine, even to design packages for other servers. Well you can do the installation, but you will not be able to do any SSIS work.

    I found this to be inconvenient to me, as I like to have SQL Express installed on my workstation for testing and experimentation with no approval process hoops or risk of breaking something important. The only solution I found was to uninstall SQLExpress, try installing SSIS, and install SQLExpress again. I didn't want to do this, as I find the more uninstalls\installs you do, the more unstable the system becomes. I ran SSIS remotely on server instead.