Gary Varga,

In my experience I use the following as a best practice:

•Validate all input parameters and throw the appropriate exception when the parameter is not correct

•Use error handling and re-throw...

My experience will echo a lot of the comments already mentioned. I use T-SQL whenever possible because, in most cases, T-SQL performs faster, it's easier to maintain and our...

While developing the project in Visual Studio, reference the DLL as you would normally. The issue is when you try to install the assembly. If the .Net DLL...

I’m assuming that the DLL is not part of the .Net framework. If my assumption is correct then the DLL needs to be added to SQL Server as an...

Great Article. I have been writing SQL Server external objects since 2007 and I have developed some best practices that work for me. You talked on most of...

The custom component needs to be installed on the development PC, which I’m assuming is your machine, and the production machine that SSIS is running on.

First off, I want to say that I’m quite impressed by the power and flexibility of SSIS, I just wished there was a better way to track data errors and...