SSIS, Tempdb Database, and SQL Server Log Files

The tempdb system database is a global resource that is available to all users connected to the instance of SQL Server. Tempdb is re-created every time SQL Server is started, which means the system always starts with a clean copy of the database and there is never anything in tempdb that is saved from one … Continue reading SSIS, Tempdb Database, and SQL Server Log Files

Changing a Connection Manager’s Conenction String using C# – SSIS 2008

A SSIS package can be run using C#, or basically any CLR language. The piece of code depicted in the following image calls a package, tries to execute it, and prints any error or exception that occurs dutring execution of the package to output: Simple and easy! Now suppose our package has 2 connection managers: … Continue reading Changing a Connection Manager’s Conenction String using C# – SSIS 2008