question

pdsqsql-8017 avatar image
0 Votes"
pdsqsql-8017 asked ZoeHui-MSFT commented

SSIS package issue with Odata

Hello,
We have issue as SSIS package was working fine and suddenly it's throwing validation error.
Actually which it's working fine on my local visual studio but when deploying on server then during validation it's having an issue.
.Net Framework is >4.6 and TLS is also latest on both the places same.

Error:
Data Flow Task - 1:Error: Cannot acquire a managed connection from the run-time connection manager.
Data Flow Task - 1:Error: Cloud OSql Attribute failed validation and returned error code 0xC020801F.

Thanks for your help!

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT commented

Hi @pdsqsql-8017,

You may try to set the project property Run64BitRuntime to False, and see if it's working.

Also I find an article, it mentioned that we may try to enforce TLS 1.2 on your machine through registry settings.

In an elevated command prompt run the following commands:
reg add HKLM\SOFTWARE\Microsoft.NETFramework\v4.0.30319 /v SchUseStrongCrypto /t REG_DWORD /d 1 /reg:64
reg add HKLM\SOFTWARE\Microsoft.NETFramework\v4.0.30319 /v SchUseStrongCrypto /t REG_DWORD /d 1 /reg:32

Please make sure that run the SSDT as administrator when deploying on server.

Regards,

Zoe


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

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks Zoe.
TLS one I have seen on one of the thread also but got little confused so didn't install but will try it out.
Somehow, it was running but making some changes into package and trying to validate, didn't work.


Thanks for your suggestions.

0 Votes 0 ·

I'll do some test locally, if you have any updates, don't forget to tell us.

0 Votes 0 ·