We have several SSIS packages that use a third party ZIP component to unzip
files that worked fine with SQL 2005 we recently upgraded to SQL 2008 and now
we cannot add a reference to that component. Here are the details any idea
how to fix it? We have tried it on four different computers with the same
results.
SQL Integration Services 2008 with Service Pack 1
Script Task
Language is set to Microsoft Visual Basic
Any custom or third party .NET DLL
Returns error "No template information found. Sell the application log in
Event View for more details
Event viewer says:
The global template information is out of date. Regenerate the templates by
running 'VSTA.exe /installvstemplates' or reinstalling the application.
Note: corrective action requires Administrator privileges.

Do what the event view says to do returns this error in a dialog box:
Command Line is not valid. Unknown Switch : installvstemplates.
Use:
vsta [projectfile | anyfile.ext] [switches]
The first argument for vsta.exe is usually a project file or the /HostID
switch. You can
also use any other file as the first argument if you want to have the file
open automatically in an editor.
Example command line:
vsta.exe /HostID ShapeAppMFC /Setup
Available command line switches:
/HostID Specifies the host identifier for which Visual Studio
Tools for
Applications will load a customized environment.
/Setup Extracts the project templates for the host application
and initializes the host-specific environment for the
current user. This switch requires administrator privileges.
/Edit Opens the specified files in a running instance of this
application. If there are no running instances, it
willstart a new instance with a simplified window layout.
/Log Logs IDE activity to the specified file for
troubleshooting.

/ResetSettings Restores the IDE's default settings, optionally resets to
the specified VSSettings file. Product-specific switches:
To attach the debugger from the command line, use:
VsJITDebugger.exe -p <pid>