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)

LVL 1
mkacosAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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?
0
mkacosAuthor Commented:
Yes
Yes, Seems ti happen on old and new packages.
Yes
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.

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.