Re: Creating configuration file failing

On Nov 19, 8:55 pm, brian_harris
<brianhar...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I have an SSIS package that I want to add a configuration file for. I go to
configuration file and enable it. when I click on ADD button I get following
error:
===================================

An error occurred while a new configuration was being added. (Microsoft
Visual Studio)

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

Specified cast is not valid. (EnvDTE)

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

at EnvDTE.IVsExtensibility.RunWizardFile(String bstrWizFilename, Int32
hwndOwner, Object[]& vContextParams)
at
Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.Ru-nAddNewItemWizard(String
pszItemName, Int32 cFilesToOpen, String[] rgpszFilesToOpen, IntPtr hwndDlg)
at
Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.Ru-nWizard(String wizardName, String newItemName)
at
Microsoft.DataTransformationServices.Design.DtsConfigurationsForm.addConfig-uration_Click(Object sender, EventArgs e)

All of my other packages in solution have configruation files defined for
them and they work fine. In fact at one point I had one working for this
package but then I did something that stopped it working, I do not know what
that was. So I removed the existing configuration file through the provided
tool. I don't remember the intial problem since this was several days ago.
But when I go to try to add new one their is no indication of the old one.
So I am looking for help on how to proceed in determining what I have done
wrong in this package.

Thanks,

Hi Brian,

Can't say I've seen this one before, but unfortunately when I've had
issues with packages that appear to have been corrupted usually the
only solution is to delete and recreate the package. You could try
doing a quick search of the package code (r-click on package in
Solution Explorer and select "View Code" - it looks a lot like XML) to
see whether the old configuration has been correctly removed. I have
found in the past that BIDS can leave ghosts of objects/variables that
I've deleted through the UI in the code behind - although this doesn't
seem to happen much since the release of SP2.

Keep us updated if you find the reason for this.
Good luck!
J
.

Quantcast