• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1619
  • Last Modified:

SSIS Error - Enabling Package Configurations

I am getting an error whenever I try to add a configuratio to a SSIS package.  

"Exception has been thrown by yhe target of an onvocation (EnvDTE)".  The advanced information about this error follows.  I get it when I click the add button.  This is a new installation of SQL Server 2008.


An error occurred while a new configuration was being added. (Microsoft SQL Server Management Studio)


Exception has been thrown by the target of an invocation. (EnvDTE)

Program Location:

   at System.RuntimeMethodHandle._InvokeConstructor(Object[] args, SignatureStruct& signature, IntPtr declaringType)
   at System.RuntimeMethodHandle.InvokeConstructor(Object[] args, SignatureStruct signature, RuntimeTypeHandle declaringType)
   at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
   at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
   at Microsoft.SqlServer.Management.UI.WizardManager10.ExecuteWizard(wizardResult& wr)
   at Microsoft.SqlServer.Management.UI.WizardManager10.Execute(Object Application, Int32 hwndOwner, Object[]& ContextParams, Object[]& CustomParams, wizardResult& wr)
   at EnvDTE.IVsExtensibility.RunWizardFile(String bstrWizFilename, Int32 hwndOwner, Object[]& vContextParams)
   at Microsoft.DataWarehouse.VsIntegration.Shell.VsProjectRoutines.RunAddNewItemWizard(Project project, IServiceProvider serviceProvider, GenerateUniqueItemNameDelegate generateUniqueItemNameDelegate, String pszItemName, Int32 cFilesToOpen, String[] rgpszFilesToOpen, IntPtr hwndDlg)
   at Microsoft.DataWarehouse.VsIntegration.Designer.DesignerService.RunWizard(String wizardName, String newItemName)
   at Microsoft.DataTransformationServices.Design.DtsConfigurationsForm.addConfiguration_Click(Object sender, EventArgs e)


Unable to cast object of type 'ApplicationObject' to type 'EnvDTE._DTE'. (Microsoft.DataWarehouse)

Program Location:

   at Microsoft.DataWarehouse.Wizards.WizardFormBase..ctor(WizardInputs wizardInputs)
   at Microsoft.DataTransformationServices.Wizards.ConfigurationWizardForm..ctor(WizardInputs wizardInputs)

1 Solution
Megan BrooksSQL Server ConsultantCommented:
Does this happen immediately when you launch the wizard? If not, when does it happen?
Does it happen if you try to add a configuration to a newly-created package? If so, something may be missing from the installation. If not, the existing package may be corrupt.
Do you have all the client tools installed plus SSIS? If not, what is not installed?
mkacosAuthor Commented:
Yes, Seems ti happen on old and new packages.
I also tried to do a repair on my installtion.  It seemed like it had nothing to repair.

I did find out that if I go into Visual Studios and start a new Integration Services Project the functionality works fine.  It just does not work from wihtin SQL Server Management Studio.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now