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.