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

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s