Author Archives
-
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 ›
-
Ho to Manage and Remove Recent Projects in Visual Studio
How to change the number of recent projects stored Visual Studio maintains a list of the most recent projects you’ve worked on so you can open them quickly. By default it maintains the 6 most recent projects on the start… 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 ›
-
How to Create a Publisher Policy Assembly
This post is only for a reference in how to create the config file and the command line arguments needed for the Assembly Linker (AL) tool to create the publisher policy file. For a full reference on how to create… Read More ›
-
Add Your Assembly to Visual Studio Add Reference Dialog
When you add a reference to a project in Visual Studio there are several tabs to allow you to “quickly” pick an assembly to reference. The .net tab is the first and, at first glance, appears to show all assemblies… Read More ›
-
Mouse won’t work in MS Word 2007 and Word Crashes on Close
I’ve had this issue a couple of times with MS Word 2007. Word won’t accept any mouse inputs, have to do every thing with the keyboard. Also, when you close Word, it crashes and tries to re-start unless you cancel… Read More ›
-
How to Schedule a Process in ASP.NET
I have on occasion needed to schedule a process to run on a nightly basis, but I did not have access to the server where I could schedule a windows service. So I had to turn to using a timer… Read More ›
-
Convert a ByteArray into a Stream
Often when you need to call a function to save a file to disk or to a database you are required to pass a .NET stream to the function but all you have is a byte array. In pre-.NET days… Read More ›
-
Installing SQL Server 2005 Reporting Service on IIS 7
I’ve had to go through installing reporting services on IIS7 a couple of times now (on Vista machines for development environments – but the same rules apply for IIS7 on Windows Server 2008). When running the install for SQL Server… Read More ›
-
Adding Controls to an ASP.NET form Dynamically
At first glance it appears that adding a control to a form dynamically is quite simple. In fact it is. It’s when you need to be able to persist that control on multiple post-backs where you start running into problems…. Read More ›