tMSSqlOutput server parameter value with \

[Anonymous]

Hi,

I have tMSSqlOutput component  is not getting configured with server parameter value as "servername\ABC"

I server parameter values is servername then tMSSqlOutput component is working fine.

I have 2 sql servers servername and servername\ABC

Please suggest how to use servername\ABC as value for server parameter in  tMSSqlOutput component ?

[fdenis]

define 2 connection into metadata (check connection) then use them into jobs.
if it's for test and prod you can define one connection with 2 context.

https://help.talend.com/reader/Q1aY_BIGldP0JPpEe5rtVw/rWyjsaXd63Yv23HTtxiuiA

regards,

[Anonymous]

but problem is servername\ABC is not getting recognized i tried

"servername\ABC"

'servername\ABC'

but no luck

[fdenis]

"servername\\ABC"
try it

[Anonymous]

\\ is not working 

[fdenis]

did define connection into metadata?
in metadata there is no java string (you do not have to surround with ") when you use this metadata parameters are going to be convert to java string (surrounded with " ad using \ as escape char).

is ABC an instance of the db on the server? if yes keep server in server and insert ABC into database name