running batch file from server

Question

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Adiga One Orange Chip Points: 27284 More actions · Answer 1

Please give some more details about the problem that you are facing.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

afgone SSCommitted Points: 1551 More actions · Answer 2

hi,

i have created a batch file which downloads files from sftp. it runs fine on my pc but when i copied them to the server, they dont run.

simply a dos opens and closes nothing happens.

now if i use ssis and include the path to the batch file i do \\servername\path....

but still nothing happens

Adiga One Orange Chip Points: 27284 More actions · Answer 3

Please go to command prompt (cmd) and run the batch file You should be getting some error there.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

afgone SSCommitted Points: 1551 More actions · Answer 4

how would i ran the batch from command line(i mean the command)

Adiga One Orange Chip Points: 27284 More actions · Answer 5

Please go to Start --> Run

Type cmd

Click Go

Then go to the directory in which the batch file exists (e.g. CD C:\WINDOWS)

Then type batch file namd and press enter.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

afgone SSCommitted Points: 1551 More actions · Answer 6

thanks.

there were some errors and i corrected them(mainly path problems). but now it says failed to connect. connection refused.

i am doing a connection using this line:

psftp username@hostname -v -bv -batch -pw password -b download.bat

and in download.bat i am changing directories and mget the files

Adiga One Orange Chip Points: 27284 More actions · Answer 7

Looks like authentication issue. Please verify that you have access to the FTP path. Try it from the browser.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga