Using xp_cmdshell to run a BAT file that uses WinSCP FTP

Advertisement

programmher
Joined:
Posts:
1

Using xp_cmdshell to run a BAT file that uses WinSCP FTP

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?

Reply with quote

Advertisement

You can post new topics in this forum