Topic "Automation problem with SQL Agent."

Author Message
David.Dx

Guest


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.
Advertisements
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 24512
Location: Prague, Czechia
Please read FAQ:
http://winscp.net/eng/docs/faq_scheduler

If that does not help, come back.
_________________
Martin Prikryl
David.Dx

Guest


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

Code:
/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
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 24512
Location: Prague, Czechia
So please post a log files both from successful and failed session.
_________________
Martin Prikryl
David.Dx

Guest


Sorry for the answer time I was pretty busy.
I'm adding log file to my process and I post this.
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.
David.Dx

Guest


I finnaly found the solution
http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/da9c4117-8f43-4c61-a1b8-6214fdb97118/

UNC file path are not my friends anymore ...
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