Cozyroc components don't seem to have registered.

[Ross Zimmerman]

VS 2022 17.7.6 with COZYROC SSIS+ version 2.2.3461

I have a brand new load of VS 2022

with SQL Server Analysis Services = 16.0.20583.0

Sql Server Data Tools 17.7.12.0

Sql server Integration Services 16.0.5314.0

and Sql Server Reporting Services 17.0.20583.0

 When I open up a Sql Server 2016 project, visual studio does not seem to recognize that CozyRoc was installed and errors out on all of the CozyRoc components. 

I have uninstalled and reinstalled cozyroc. Repaired the VS installation, as well as the IS installation and the DT installation.

What else might I be missing that would keep VS from recognizing cozyroc components?

[Ivan Peev]

Hi Ross,

Please open a ticket at our help desk here: desk.cozyroc.com

[Ross Zimmerman]

Submitted... Thanks.

[Phillip Hoffman]

Ross,

I went through something similar recently after upgrading our SQL Server from 2016 to 2019 (and VS 2019, yes, I know it's almost 2024, got behind a bit). I had the same symptoms. Don't know if this will help, but it's easy, so thought I'd pass it along. 

I also upgraded to CozyRoc 2.1 at this time. When I installed 2.1 I had selected support for 2016 and 2019 only, my previous and upgraded versions of SQL Server. At some point after days of troubleshooting and no luck, I reinstalled CozyRoc with support for all versions of SQL support (even 2008). This solved my problem. Everything worked fine after that.

Luck,

- Phillip

[Ross Zimmerman]

Thanks for the suggestion Phillip. I went back and double checked but I had chosen to install all of the feature set of cozyroc 2.2 Beta 1. So I guess that wasn't it. I did get a slight bit farther by changing the protection type from EncryptSensitiveWithUserKey to EncryptSensitiveWithPassword. It at least recognized the database connections this way. But the SMTP+ connection is flat out missing.

Severity Code Description Project File Line Suppression State
Error Error loading ****************.dtsx: Cannot create a task from XML for task "Send Mail Task Plus", type "CozyRoc.SendMailTask" due to error 0x80070057 "The parameter is incorrect.".

Support already had me create a new 2022 project with a new package, and with that, all of the cozyroc components show up just fine, and I can add/edit them appropriately.