I’ve been a software engineer for almost 2 decades now, and I love it. I spent much of that time teaching others how to program, and it amazes me how much I love watching others get as excited about… Read More ›
SSIS
SSIS – How To Save a Package as a Template
When creating SSIS packages, you may need to set up common steps, connections or variables. For instance it is possible that you create the same type of package frequently but with slightly different configurations. Visual Studio allows you to save… Read More ›
Connect to SSIS on a Named Instance of SQL Server
The Problem: Can’t Connect to Named Instance of SSIS in Management Studio I’ve occasionally run into the following error when attempting to connect to SSIS from Management Studio: “Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) The SQL Server specified… Read More ›