Hi, I am facing issue in using Microsoft SQL Server BCP to connect to a SQL Server on some other port then default one.
It does not provide separate field to provide Port number.
1. When I am trying to import profile in Connector Operation, it expects "Server Name" to be put as "<serverName>:<portNumber>"
While, when I actually want to run this process, it expects Server Name" to be put as "<serverName>,<portNumber>".
I guess differences are due to fact that, Connector Operation is based on Java/Boomi classes whereas actual BCP utilizes bcp.exe from Microsoft.
Can you please resolve this issue by providing port number field in this connector and handling these things inside boomi?