SSIS – Failed to start project Exception deserializing the package “Value does not fall within the expected range”

Possibly save 1 hour of your time: I got this error after making some changes to packages.

I replace with version control one and still got this error. So I then look at other changes I have made.

I created lots of stuff. I have the luxury to revert my code based on source control. And the error goes away.

Later on as I add my code back, I discover the error has to do with SMTP connection manager used for sending email. I linked this connection manager to Send Mail Task Editor.

There is a bug when you setup your SMTP connection manager at the project level.

Bug:

https://social.technet.microsoft.com/Forums/WINDOWS/en-US/0fcddaaf-813c-48dc-a40b-c0f9aa396fa2/smtp-connection-level-project-doesnt-work?forum=sqlintegrationservices

Solution:

It will work if you change it to the package level.

Versions:

After you check your version number using Add/Remove Programs, you can compare your version here at

https://docs.microsoft.com/en-us/sql/ssdt/changelog-for-sql-server-data-tools-ssdt

I am running

  • SSDT 17.2 for Visual Studio 2015
    Build number: 14.0.61707.300

 

Book: Professional Microsoft SQL Server 2012 Integration Services

Advertisements

3 thoughts on “SSIS – Failed to start project Exception deserializing the package “Value does not fall within the expected range”

  1. thank you so much for posting this. None of the other posts about this error message were relevant to what I was doing and finally this popped up and lo and behold, this was exactly my problem. I had promoted my smtp connection to project!

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s