How to add to VS Toolbox

Aug 10, 2010 at 12:34 PM

 

Hi

 

Just wondering how to add the Batch Destination to the toolbox in Visual Studio?

I added it to the GAC, by simply dragging and dropping the dll.

I also copied it to the C:\Program Files\Microsoft SQL Server\100\DTS\PipelineComponents directory

When I go to add the file in the Toolbox in Visual Studio it returns an error saying that there are no components found to be placed on the toolbox?

If anyone has any ideas that would be great.

Cheers

Moe

Coordinator
Aug 11, 2010 at 3:04 AM

Are you on an x64 machine? If so, you need to copy it to the "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\PipelineComponents" directory as well.

Aug 11, 2010 at 7:59 AM
In addition you may need to stop and start the "SQL Server Integration Services" service,as it can cache component info.
Aug 11, 2010 at 11:06 AM

 

Thanks guys

I actually just recompiled the dll and I noticed the file size was different to the one I downloaded here.  As soon as I had overwritten the dll in both GAC and Pipelines directory it worked.

Cheers

Moe