Automation problem with SQL Agent.

Advertisement

David.Dx
Guest

Automation problem with SQL Agent.

Hi all,

I have some problem with WinSCP when I want to use it with SQL Agent.
I have a SSIS package which use WinSCP with an "Execute Process Task" toolbox.
The package runs with success.

When I put my package on my SQL Server File System it still works correctly.
But when I try pour launch my package with SQL Agent (in order to automate the job), the job starts and run without end.

Reply with quote

Advertisement

David.Dx
Guest

Unfortunately I'm already doing this.
Here's my command line:

/command "option batch on" "option confirm off" "option transfer binary" 
"open sftp://[Login]:[Password]@[Host]:[Port] -hostkey=""ssh-dss 1024 [HostKey]"" -timeout=120"  
"cd /incoming" "put -nopreservetime -nopermissions [FilePath]" "exit"

[xxx] are variable name in SSIS

Note: When I execute my package using dtexec.exe nothing goes wrong

Reply with quote

martin
Site Admin
martin avatar
Joined:
Posts:
28,658
Location:
Prague, Czechia

So please post a log files both from successful and failed session.
_________________
Martin Prikryl

Reply with quote

Advertisement

David.Dx
Guest

Unfortunately, the job run with SQL Agent doesn't generate any log file.
So this means that WinSCP is not launch.

WinSCP is not the problem.
Thanks for the help.

Reply with quote

Advertisement

You can post new topics in this forum