Script Task/Component and Template Information

by Allan Mitchell 8 Dec 2009 06:46

The Script Task and Script component are often used by people developing SSIS packages because they are easy to use and now because SSIS could be perceived to be more developer friendly they are very powerful.

That being said we should no be using them everywhere.  There are generally Tasks/Components already provided that will do the job it may be that we have to rethink the way we want to draw our package.

I had cause last week to break out the script component in SQL Server 2008 SP1 and found that it was broken.  I don’t know when it broke as I do not use them all that often.  My error was as below.



Something must have overwritten this template information.  I looked in Event Viewer and tried the things it suggested but the templates still did not work.  Here is how I got them eventually to work for me (Your Mileage may vary)

Open up a Command Prompt window using an administrator level account and “as an administrator”

vsta.exe /hostid SSIS_ScriptTask /setup

vsta.exe /hostid SSIS_ScriptComponent /setup


This worked for me.  Hope it helps.

Comments (1) -

4/3/2012 2:23:54 PM #

mario amatucci

Hi I've got this error
when I switch to c# language instead of the default vb, I am pretty sure I need to reference some dll before, can you help me?
thanks, mario

mario amatucci Ireland

Add comment

  Country flag

  • Comment
  • Preview

Popular this month

No post views yet...