• SSIS is a windows based service that gets installed if you select it as a component during the initial SQL Server installation. It is different than the BIDS GUI that you use to build or design packages and which lets you execute the packages.