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
Monthly Archives: July 2012
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.
Part of the beauty of using LeapFrogBI to define your data mart is how easy it is to make modifications. One example of this is the “Redirect Source” feature. With this feature a component’s source can be changed by simply
LeapFrogBI provides a toolset that not only streamlines initial data mart deployment, but also greatly simplifies incremental modification tasks. There are a few points that must be understood to get the most out of LeapFrogBI.
– LeapFrogBI does not connect
When building SQL Server data warehouses should user-defined schemas be used? Should tables and views be prefixed? Or, maybe we should do both. After talking to a few people about this and doing a little research, one thing is clear.