SQL Server Integration Services offers developers a powerful toolset capable of performing a wide range of integration tasks. Data mart developers will typically design numerous SSIS packages which will create and maintain the target data mart. There are an array
There are several ways to control the order of execution of deployed components.
– Create multistep Agent jobs
– Create parent packages
– Deploy to msdb & query sysssispackages to get package list. Loop through packages in SSIS.
There are three dimension component templates; d1000, d1001, & d2000. d2000 is used when a dimension already exist & the current project needs to utilize it. The other two templates will both load a dimension while taking care of scd