|

Override SSIS package configurations through an SQL Server 2008 R2 Job

ByAdam Gilmore

If you thought you could override an SSIS package’s configurations when running it through an SQL Server 2008 R2 Job… think again. In the SQL Server Job Step Properties dialog, there is a  Configuration tab that allows you to specify configuration files. The logical assumption is that this will override existing configurations with the same…

Connecting to Client's Servers via VPN

ByAdam Gilmore

Here at Dimodelo Solutions we often work remotely. With today’s technology, we can use Virtual Private Network (VPN) technology to securely connect into our client’s network and access their Servers, as if we were there on site. All that is required is the appropriately authorized Server credentials (User Name and Password) and a VPN Server configured at the client site. Today,…