SSIS Extensions SQL 2012 Installation Error

Feb 26, 2013 at 5:15 PM
Hello,

I am experienced an issue when I try to install the Installation package for SQL 2012. (x86 or 64bit version).

I try to install the package in my development computer :
  • Windows 7 Enterprise 64Bit
  • VS 2010 Pro SP1 with SQL Server 2012 Data Tools. (see VS 2010 Infos at the post end)
When I launch the installation package I have the following error :
"This application requires SSIS 2012".

I have installerd successfully the extension directly on the SQL Server 2012 server, but I will like to be able to install it on my development computer.

Regards

PS VS 2010 Infos :
Microsoft Visual Studio 2010
Version 10.0.40219.1 SP1Rel
Microsoft .NET Framework
Version 4.0.30319 SP1Rel

Installed Version: Professional

Microsoft Office Developer Tools   01018-532-2002181-70235
Microsoft Office Developer Tools

Microsoft Visual Basic 2010   01018-532-2002181-70235
Microsoft Visual Basic 2010

Microsoft Visual C# 2010   01018-532-2002181-70235
Microsoft Visual C# 2010

Microsoft Visual C++ 2010   01018-532-2002181-70235
Microsoft Visual C++ 2010

Microsoft Visual Studio 2010 Team Explorer   01018-532-2002181-70235
Microsoft Visual Studio 2010 Team Explorer

Microsoft Visual Studio Tools for Applications 3.0   01018-532-2002181-70235
Microsoft Visual Studio Tools for Applications 3.0

Microsoft Visual Web Developer 2010   01018-532-2002181-70235
Microsoft Visual Web Developer 2010

Crystal Reports Templates for Microsoft Visual Studio 2010   
Crystal Reports Templates for Microsoft Visual Studio 2010

Hotfix for Microsoft Visual Studio Team Explorer 2010 - ENU (KB2662296)   KB2662296
This hotfix is for Microsoft Visual Studio Team Explorer 2010 - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2662296.

Microsoft Visual Studio 2010 SharePoint Developer Tools   10.0.40219
Microsoft Visual Studio 2010 SharePoint Developer Tools

Microsoft Visual Studio Team Explorer 2010 - ENU Service Pack 1 (KB983509)   KB983509
This service pack is for Microsoft Visual Studio Team Explorer 2010 - ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/983509.

NuGet Package Manager   2.2.31210.9045
NuGet Package Manager in Visual Studio. For more information about NuGet, visit http://docs.nuget.org/.

SQL Server Analysis Services   
Microsoft SQL Server Analysis Services Designer 
Version 11.0.2100.60

SQL Server Data Tools   10.3.20905.0
Microsoft SQL Server Data Tools

SQL Server Integration Services   
Microsoft SQL Server Integration Services Designer
Version 11.0.2100.60

SQL Server Reporting Services   
Microsoft SQL Server Reporting Services Designers 
Version 11.0.2100.60
Mar 1, 2013 at 12:12 AM
Installation is looking for the following registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\110\DTS\Setup\SQLPath. This is crated by SQL server 2012 install. Does this exist on your system? Is the path different on your system for this key? Also, do you have access to read the registry, might need to run as administrator.
Mar 21, 2013 at 10:54 AM
Hi,

I created the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\110\DTS\Setup\SQLPath and then I have succesfully installed the SSIS Extensions package.

But now when I want to use the Zip Task component, I have the following error when I want to open the task editor :
TITLE: Microsoft Visual Studio
------------------------------

Cannot show the editor for this task.

------------------------------
ADDITIONAL INFORMATION:

The task user interface specified by type name 'SSIS.Extensions.UI.ZipTask.ZipUI,SSIS.Extensions.UI,Version=2.0.0.0,Culture=neutral,PublicKeyToken=be2dd18b41995f85' could not be loaded. (Microsoft.DataTransformationServices.Design)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%C2%AE%20Visual%20Studio%C2%AE%202010&ProdVer=10.0.40219.1&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=CouldNotLoadTaskUIForType&LinkId=20476

------------------------------

Could not load file or assembly 'SSIS.Extensions.UI, Version=2.0.0.0, Culture=neutral, PublicKeyToken=be2dd18b41995f85' or one of its dependencies. Le fichier spécifié est introuvable. (mscorlib)

------------------------------
BUTTONS:

OK
------------------------------
The detailled error informations :
===================================

Cannot show the editor for this task. (Microsoft Visual Studio)

===================================

The task user interface specified by type name 'SSIS.Extensions.UI.ZipTask.ZipUI,SSIS.Extensions.UI,Version=2.0.0.0,Culture=neutral,PublicKeyToken=be2dd18b41995f85' could not be loaded. (Microsoft.DataTransformationServices.Design)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%C2%AE%20Visual%20Studio%C2%AE%202010&ProdVer=10.0.40219.1&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=CouldNotLoadTaskUIForType&LinkId=20476

------------------------------
Program Location:

   at Microsoft.DataTransformationServices.Design.DtrTaskDesigner.InitializeTaskUI(Boolean throwOnError)
   at Microsoft.DataTransformationServices.Design.DtrTaskDesigner.GetTaskEditor()
   at Microsoft.DataTransformationServices.Design.DtrPackageDesigner.DoDefaultActionForTask(TaskHost task)

===================================

Could not load file or assembly 'SSIS.Extensions.UI, Version=2.0.0.0, Culture=neutral, PublicKeyToken=be2dd18b41995f85' or one of its dependencies. Le fichier spécifié est introuvable. (mscorlib)

------------------------------
Program Location:

   at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMarkHandle stackMark, Boolean loadTypeFromPartialName, ObjectHandleOnStack type)
   at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, Boolean loadTypeFromPartialName)
   at System.RuntimeType.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark)
   at System.Type.GetType(String typeName, Boolean throwOnError)
   at Microsoft.DataTransformationServices.Design.DtrTaskDesigner.InitializeTaskUI(Boolean throwOnError)

May 19, 2013 at 6:15 PM
Fixed the issue in the new release.
Mar 7, 2014 at 7:03 PM
I just downloaded the lastest build and get the same "Cannot show editor for this task" error for the Zip task.
Mar 13, 2014 at 2:22 PM