how to fix : Integration Services evaluation period has expired

Question

Hello

I have Visual Studio professional 2019 in my workstation with license for sure, and I have enterprise SQL Server 2017 in server(different machine from my workstation) with license for sure.

Recently I tried to modify a little bit my ETL process with Visual Studio professional 2019 on my workstation anf then ran it, but I got below error message:

"Warning: Integration Services evaluation period has expired. The package can only be executed in debug mode.". this ETL process worked fine in my development environment.

Please help with this, how I can get rid of this and I can test my ETL process after modification?

Thanks in advanced

Robert

Answer 1

Hi Robert,

The error message means that the SSIS runtime or components installed on your development workstation are running under an expired trial license.

Even though you have a valid SQL Server Enterprise 2017 license on your server, the SSIS tools and runtime on your local machine (where Visual Studio 2019 is installed) need their own licensed version of the Integration Services runtime to run packages outside of debug mode.

Install licensed SSIS runtime on your workstation - If you want to run or test your package locally without debug mode restrictions, you need to install the full licensed Integration Services feature matching your SQL Server version.

Please also make sure there are no expired trial versions of SQL Server or SSIS components on your workstation.