value doesn't fall within expected range (microsoft.sqlserver.ManagedDTS)

Question

value doesn't fall within expected range (microsoft.sqlserver.ManagedDTS)

Kaveya S 6

i have to deploy SSIS project developed in visual studio 2019 into SQL server 2017. i have newly adde some execute sql tasks and rebuild the solution. Then I try to deploy it in SSMS it got the error as
value doesn't fall within expected range (microsoft.sqlserver.ManagedDTS). after removing those execute sql task, the project deployed successfully. i restarted visual studio. But still error persists.
Kindly provide me with perfect solution for this.

Veena 0 Reputation points

2023-11-20T13:37:17.74+00:00

While exporting SSIS pkg from SQL Server Management Studio I’m getting error like Value does not fall within the expected range.(Microsoft.sql server.ManagedDTS) .

Can you please help me on this

Thanks in Advance

Veena

2 answers

Your answer

Veena 0 Reputation points

2023-11-20T13:37:17.74+00:00

While exporting SSIS pkg from SQL Server Management Studio I’m getting error like Value does not fall within the expected range.(Microsoft.sql server.ManagedDTS) .

Can you please help me on this

Thanks in Advance

Veena

Answer 1

Yitzhak Khabinsky 27,091

Hi @Kaveya S ,

(1) You need to check SSIS Project ProtectionLevel setting value.
It is recommended to set it as DontSaveSensitive.

It may ask you to set the same ProtectionLevel value for each SSIS package in the project.

(2) Please ensure that you are using SQL Server Integration Services Projects extension for VS2019 v3.16, and ignore v.4. versions.
(3) If you are using SSIS Script Task, please check that VS2019 .Net Framework version is installed on the SSIS run-time server.
(4) Please ensure that SSIS project TargetServerVersion is matching SSIS run-time version on the server.

Kaveya S 6 Reputation points

2022-12-21T08:12:34.373+00:00

Hi,
I opened SSIS project and packages. all have same protection level DONTSaveSensitive. But still error persists
Yitzhak Khabinsky 27,091 Reputation points

2022-12-21T13:47:18.687+00:00

@Kaveya S ,

I updated the answer.
Check it out.
Kaveya S 6 Reputation points

2022-12-21T14:16:00.777+00:00

thanks
Kaveya S 6 Reputation points

2022-12-21T14:20:30.593+00:00

i will check these and update
Kaveya S 6 Reputation points

2022-12-23T14:37:05.83+00:00

HI, still error didn't get solved tried out all those solutions.
Yitzhak Khabinsky 27,091 Reputation points

2022-12-23T16:29:31.543+00:00
@Kaveya S ,

Please add to the original questions screen shots of the problematic SSIS Execute SQL Task, specifically its two tabs:

General

Parameters Mapping

There is a possibility that parameters data types and/or values don't match data types of the database table(s).
Kaveya S 6 Reputation points

2022-12-26T14:41:29.917+00:00

Thanks. I will try it out.

Answer 2

ZoeHui-MSFT 41,531

Hi @Kaveya S ,

The error message tells us that you need to change protection level.

See access-control-for-sensitive-data-in-packages.

Regards，

Zoe Hui

If the answer is helpful, please click "Accept Answer" and upvote it.

Kaveya S 6 Reputation points

2022-12-21T14:21:29.317+00:00

thanks. But i already did this. still error occurs.

Share via

value doesn't fall within expected range (microsoft.sqlserver.ManagedDTS)

2 answers

Your answer