You can design your SSIS packages in various ways, but you should always keep your goals and other factors in mind The other night, I gave a presentation on SSIS architecture to a local user group, ...

Calling an SSIS package from another SSIS package is, on the surface, a simple task. You just use the Execute Package Task and point it to a package on a SQL Server ...

When deploying SQL Servers and when you need to implement some of kind of business intelligence, chances are you're going to need a SQL Server Integration Services (SSIS) catalog. A SSIS catalog is a ...