SSIS Customs connections are not getting fetched as part of Microsoft.SqlServer.Dts.Runtime.Connections using sql version 2022

Question

Hi Team,

I am using custom component for ssis .

It works fine for sql 2016 using vs2019 but as soon as i change the target sql version to 2022 ,it doesn't worked.

While debugging i found that the connection which i created using custom connection manager is not populated as part of "Connections" and its count is 0 :

public override DTSExecResult Validate(Connections connections, VariableDispenser variableDispenser, IDTSComponentEvents componentEvents, IDTSLogging log){}

Hence i am not able to fetch and use the connection in the subsequent task.

Please let me know if i am missing something.

Thanks,

Sanjay

Answer 1

Hi @Sanjay Sharma

Please also raise the issue here to see if it is a known issue, the product team will help resolve it.

Regards，

Zoe Hui