COMException when creating SSIS Package / DataSource

I'm running sql2000 and 2005 (RTM) side by side (and vs2003 and 2005 RTM). I want
to create a IntegrationServices project.

When i want to create a DataSource, i can specify the connection, but
when i click on finish the screen is not closed whatever info/name/etc.
i fill in. I can only cancel the dialog box.

When i add a new SSIS package i get this exception:
===================================

Error creating package (Microsoft Visual Studio)

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

Exception of type 'System.Runtime.InteropServices.COMException' was
thrown. (Microsoft.DataWarehouse.VsIntegration)

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

   at
Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy
.OnHierarchyNodeAppending(IHierarchyNode node, IHierarchyNode
parentNode)
   at
Microsoft.DataWarehouse.VsIntegration.Hierarchy.Hierarchy.Add(IHierarchy
Node node, IHierarchyNode parentNode)
   at
Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy
.AddExistingFileToProject(IFileProjectNode& parentNode, String name,
String fullPath, VSADDITEMOPERATION dwAddItemOperation)
   at
Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy
.AddNewFileToProject(IFileProjectNode& parentNode, String name, String
sourceFullPath, VSADDITEMOPERATION dwAddItemOperation)
   at
Microsoft.DataWarehouse.VsIntegration.Shell.Project.Extensibility.Projec
tItemsExt.AddFromTemplate(String FileName, String Name)
   at
Microsoft.DataTransformationServices.Wizards.WizardUtils.AddProjectItemF
romTemplate(WizardInputs wizardInputs, String path, String itemName,
Boolean activateWindow)
   at
Microsoft.DataTransformationServices.Wizards.Dts90WizardSaveNewTask.AddP
ackageToProject(Package package, String itemName)
   at
Microsoft.DataTransformationServices.Wizards.Dts90WizardSaveNewTask.Crea
teAndAddPackageToProject()
   at
Microsoft.DataTransformationServices.Wizards.Dts90WizardSaveNewTask.Exec
ute(WizardInputs wizardInputs)

Any idea what's causing this ( i reinstalled SQL 2005/SSIS several
times)

Thanks
Marco

Answer this question

COMException when creating SSIS Package / DataSource

kelz1004
Yes. i'm using DevExpress CodeRush/Refactor... no source control integration.

Thanks

Marco
Spearhead127
Could you please try removing the DevExpress add-in and see if this fixes the situation Looking at our code - we are simply notifying environment about new file, and some external code subscribed to this event reports failure, thus cancelling adding a new file. Since it does not happen normally, I suspect the DevExpress add-in causes this.

I'll try to get my hands on the DevExpress CodeRush/Refactor to check what's going on.
Intech Techie
Do you use any third-party add-ins for Visual Studio
Do you use source control integration with Visual Studio,
if yes - which source control provider
mabxsi
Thanks!

Disabling fixed the problem.. I will send my errorreport also to DevExpress.

Marco
COMException when creating SSIS Package / DataSource

Answer this question