SSIS Packages SSIS in SQL Server 2014 allows for dynamic packages enabling values within the package to be manually set depending on your requirements at execution time. Discover what’s involved in designing SSIS packages.