-S Command in DWLoader

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Hi,

I am new to SQL Server PDW, I have a requirement to load a text file into PDW through dwloader.exe. The destination PDW server name is like "10.120.263.154,17005".
When I am trying to connect to this server through dwloader.exe command line utility, i am getting an error like "No such host exists". I think i am receiving this error due to the presence of port number in the server name. I tried to provide an escape character for "comma" in the server name but no success. Could you help me how to give the servername properly??

Posted 10-Nov-14 0:15am

dinesh42

Add a Solution

Comments

barneyman 10-Nov-14 16:59pm

can you ping that IP address? also, none of the docs for dwloader i read quote the requirement for a port number, and traditionally port numbers are delimited with a ':' i.e. 10.120.263.154:17005

dinesh42 11-Nov-14 2:29am

I am able to ping the IP without port number. But when i give port number with ":" or "," i am unable to ping.

barneyman 11-Nov-14 3:07am

ping only works on the icmp port - sounds like you have a firewall problem, either on the destination machine, or on an intermediate router if you're not on the same subnet

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)