How to Set SQL Server Integration Services (SSIS) Protection Levels

I’m using SQL Server Integration Services (SSIS) to clone a database. I’m doing this for a customer in order to off-load the querying and reporting functions from their main Configuration Manager database server. When I built the SSIS package, I needed to embed a few...

How to Install SQL Server Integration Services Tools

I’m working on a project to clone a SQL Server database (aka the ConfigMgr database) because a customer wants all querying and reporting off-loaded from the main ConfigMgr database server. Instead of using SQL Server Replication we’re going to use SQL Server...