AnsweredAssumed Answered

Issue in Microsoft SQL Server BCP Connector

Question asked by vshah01248 on Mar 23, 2017

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?

Outcomes