I've created sereral SSIS packages in Visual Studio 2012 and they can be executed without any problems.
For a project I'm working on I generate packages using BIML. In my BIML script I create a package for each databaseview in two defines databaseschemas. For example:
- [crm].[contact]
- [crm].[account]
- [navision].[vendor]
- [navision].[customer]
The name of the packages will be [schemaname] viewname, e.a. "[crm] contact".
When I start a package in Visual Studio I get the message "Failed to start project" see below.
"Exception deserializing the package. "Specified part does not exist in the package".
Why is this error occurring?
Best Answer
When troubleshooting the error I've searched the internet for possible solutions. The main solution to this error is the 32bit / 64bit excecution of SSIS.
Because I can run other packages without any problems all posible solutions I found regarding configuration of packages, SSIS and Visual Studio didn't apply.
Maybe I did something wrong when I generated the packages with BIML, so I started with an empty package and see if it ran.... Still the same error.
Eventually i changed the name of the package to "crm contact" and it ran. It seems that using blockquotes ( [ ] ) in the name gave the error.