topic Re: tMSSqlOutput server parameter value with \ in Talend Studio

tMSSqlOutput server parameter value with \

Anonymous — Sat, 16 Nov 2024 03:34:10 GMT

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 ?

Re: tMSSqlOutput server parameter value with \

fdenis — Thu, 16 Jan 2020 09:45:41 GMT

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,

Re: tMSSqlOutput server parameter value with \

Anonymous — Thu, 16 Jan 2020 14:24:46 GMT

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

"servername\ABC"

'servername\ABC'

but no luck

Re: tMSSqlOutput server parameter value with \

fdenis — Thu, 16 Jan 2020 14:35:57 GMT

"servername\\ABC"
try it

Re: tMSSqlOutput server parameter value with \

Anonymous — Fri, 17 Jan 2020 01:27:59 GMT

\\ is not working

Re: tMSSqlOutput server parameter value with \

fdenis — Fri, 17 Jan 2020 10:00:30 GMT

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