Tag Archives: Ssis

SQL Server Integration Services

Presentation Files: 10 Things All BI Administrators Should Know

September 29, 2011 9:44 pm / Leave a Comment /

Presentation Files: 10 Things All BI Administrators Should Know I was very excited to get to present to the Pensacola SQL Server User Group tonight. I lived in Pensacola for a few years when I was a kid. I have a lot of memories from Pensacola like dancing to disco music on the dance floor … Read More →

Posted in: SQL Server / Tagged: , ,

You Got Your Integration Services in My Database Engine

November 13, 2010 10:40 pm / Leave a Comment /

You Got Your Integration Services in My Database Engine When I first looked at Object Explorer in SSMS (SQL Server Management Studio) after installing SQL Server Denali CTP1, something looked out of place. I compared Object Explorer in Denali’s SSMS to the same in SQL Server 2008 R2, and it was immediately noticeable. There is … Read More →

Posted in: SQL Server / Tagged: , ,

How Do I Configure SSIS to Work With a Named Instance

December 11, 2008 6:56 pm / Leave a Comment /

How Do I Configure SSIS to Work With a Named Instance By default, SSIS (SQL Server Integration Services) uses the msdb database of the default instance on the server for storing packages. SSIS can still manage packages stored as files in the file system without any changes to the current setup. To be able to … Read More →

Posted in: SQL Server / Tagged: , ,