Wednesday 28 November 2007

First post

Hello!

My first post relates to installing custom SSIS tasks. Here's a simple batch script to do it. The way it works assumes you have gacutil.exe, gacutil.exe.config and the SSIS custom task assembly in the same folder as the batch script:



rem Install custom task
@echo off
set Task=<Insert Task Name>.dll
rem copy task to task folder
copy /y /v %Task% "c:\Program Files\Microsoft SQL Server\90\DTS\Tasks"

rem execute gacutil to add to GAC
gacutil.exe /if "c:\program files\Microsoft SQL Server\90\DTS\Tasks\%Task%"
@echo Successfully installed
pause





The /if switch ensures that any previous version of the assembly is forcibly overwritten. By the way if you're struggling with Vista permissions shift+right-click on the batch file and select 'Run as administrator'. If you're looking for the .Net 2.0 gacutil its in %Program Files%\Microsoft Visual Studio 8\SDK\v2.0\Bin assuming you have Visual Studio 2005 installed of course.

Obviously this doesn't add it to the Business Intelligence Design Studio toolbox - you have to do that manually (right-click 'Choose Items...' etc, etc).

Hopefully I'll have more interesting posts in the future...