MySQL Connection Manager Advanced Properties in Expression editor

Discussion of issues, suggestions and bugs of Devart SSIS Data Flow Components, our product line for building SSIS-based ETL solutions, performing data access to popular cloud applications and databases.
Post Reply
Christian P
Posts: 5
Joined: Sun 24 May 2020 14:17

MySQL Connection Manager Advanced Properties in Expression editor

Post by Christian P » Sun 24 May 2020 14:41

Hi folks,

I need to configure my packages' MySQL connection to operate in different environments (dev, stage and prod).
Our MySQL databases access is over SSH.

I have added the remote server's name as and expression @[User::RemoteServer] to the expression editor's 'Server' property and I need to do them same for the SSH Host. However the Advanced Properties like 'SSH Host' doesn't appear in the expression editor's property list!

Any workaround, other than putting the whole connection string as an expression into the the 'ConnectionString' property?

Cheers

Shalex
Site Admin
Posts: 9302
Joined: Thu 14 Aug 2008 12:44

Re: MySQL Connection Manager Advanced Properties in Expression editor

Post by Shalex » Tue 09 Jun 2020 18:56

Property Expressions Editor allows setting expression for the connection properties from Devart MySql Connection Manager only (properties from Advanced tab are not available). As a workaround, please set an expression for the whole connection string via the ConnectionString property.

Post Reply