Topic "Using xp_cmdshell to run a BAT file that uses WinSCP FTP"

Author Message
programmher
[View user's profile]

Joined: 2016-12-01
Posts: 1
I am trying to use xp_cmdshell to run a .bat file that uses WinSCP to FTP a .csv file.

I have verified all permissions and can successfully run a .bat file that does not use WinSCP.

I do not get any errors and my xp_cmdshell just runs and runs and runs without logging any errors.

We have created a profile in WinSCP for the SQL server agent that the xp_cmdshell is run.

We can manually run the .BAT file.

How do we resolve this issue to run this .BAT file using xp_cmdshell?
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 25946
Location: Prague, Czechia
So does it log anything or not? Show us any log file you have.

Also make sure you have read this:
https://winscp.net/eng/docs/faq_scheduler
Guest




martin wrote:
So does it log anything or not? Show us any log file you have.

Also make sure you have read this:
https://winscp.net/eng/docs/faq_scheduler


Nothing is logged. The proc just runs and runs.

I will review the link you forwarded.
Advertisements

You can post new topics in this forum






Search Site

What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License