batch file - SQL Server agent for scheduling SFTP using WinSCP under SSIS -


i have batch script generates winscp upload script upload file sftp location. when run batch file via command prompt - runs , loads it. called same thru ssis execute process task - runs , loads it. when put same on sql agent - tried following 2 options:

  1. using operating system (cmdexec) - cmd.exe /c "\.bat"
  2. added ssis package ssisdb , added job step.

with both above options job showed successful run. file not uploaded! ideas on happening?

here's batch script:

echo off set winscp=c:\"program files (x86)"\winscp\winscp.com set stagingdirectory=\\<staging path>\ set scriptpath=\\<scriptpath>\uploadscript.txt set ftphost=xx.xx.xx.xx set ftpuser=user set ftppass=password set filename=test.xlsx set ftpflags= @rem ftpflags: -explicit  echo deleting uploadscript if exists  if exist %scriptpath% del /f %scriptpath% if exist %scriptpath% exit 1  echo generating winscp upload script  >>%scriptpath% echo option batch abort >>%scriptpath% echo option confirm off >>%scriptpath% echo open sftp://%ftpuser%:%ftppass%@%ftphost% %ftpflags% >>%scriptpath% echo option transfer binary >>%scriptpath% echo put %stagingdirectory%%filename% / >>%scriptpath% echo close >>%scriptpath% echo exit  echo launching winscp upload  start /wait %winscp% /console /script=%scriptpath%

as start winscp via start (why?), exit code not propagated ssis. so, never learn, if script fails. , fails.

you should enable logging, can see what's wrong.

you should use code propagate winscp exit code ssis , enable logging:

%winscp% /log=\\<scriptpath>\uploadscript.log /script=%scriptpath% exit /b %errorlevel%

(note winscp.com not have /console parameter)

anyway, 1 clear problem not specify expected ssh host key in script. when run script manually, have key cached in registry of windows account. under ssis different account used, , host key cache empty. should add -hostkey switch open command in script make script independent on cache. see where ssh host key fingerprint authorize server?

when testing script, add /ini=nul parameter isolate script configuration.

for , other hints, when debugging winscp running under ssis, see my script works fine when executed manually, fails or hangs when run windows scheduler, ssis or other automation service. doing wrong?

and finally, see winscp sftp task ssis.


Comments

Post a Comment

Popular posts from this blog

html - Outlook 2010 Anchor (url/address/link) -

i'm trying link specific pdf page msoutlook'10 or msword'10, #page=... anchor particularly useful , works fine elsewhere. unfortunately when click [ctr-k] in outlook or winword, links re-formatted assuming unc path. pdf file located on shared drive. using "file:" prefix links open pdf in adobe reader (outside of browser), , "http:" open inside browser. issue seem need open in browser "file:" prefix in order anchor work. know anchors work inside browser. outlook uses windows/explorer default program (based on file extension) seems open in adobe reader neglecting anchor. is aware of solution, link specific page or bookmark of shared-pdf ms outlook and/or winword link? common references: mailermailer.com/...anchor-tags-html-emails campaignmonitor.com/...anchor-links-in-email-newsletters/ stackoverflow.com/...anchor-in-pdf-document
Read more

javascript - Why does running this loop 9 times take 100x longer than running it 8 times? -

consider code: test = function() { } t = new test(); (var = 0; < 8; i++) { result = t instanceof test; } if change number of iterations 8 9 , loop take 100 times longer complete in latest version of firefox (41.0.1). tested on 2 different pcs , magic limit 8. here jsperf test used: http://jsperf.com/instanceof-8-times-vs-9-times does have idea why might happen? seems specific instanceof . not happen if else object, example check property. note: filed bugzilla bug this. jan de mooij mozilla team has posted details in bugzilla thread . here's simplistic interpretation of highly technical answers: in i < 8 case, firefox smart enough hoist result = t instanceof test; statement out of loop (according tests, doesn't seem omit altogether). in i < 9 case, apparently doesn't optimization . why? reason not clear, related fact 9 iterations threshold above function considered "hot" enough run through jit compiler. i < 8 cas...
Read more

Getting gateway time-out Rails app with Nginx + Puma running on Digital Ocean -

following this guide setup app on digital ocean droplet, not working. site not loading , it's throwing: "gateway time-out". the puma server works, since ps aux | grep puma prints: root 15878 0.0 0.4 376832 2168 ? sl 12:50 0:00 puma 2.13.4 (unix:///var/www/myapp/shared/tmp/sockets/myapp-puma.sock) [20150930164940] root 15881 0.0 0.7 903676 3692 ? sl 12:50 0:06 puma: cluster worker 0: 15878 [20150930164940] root 24654 0.0 0.1 11748 916 pts/2 s+ 18:00 0:00 grep --color=auto puma my nginx config: user root; worker_processes 1; events { worker_connections 1024; } http { upstream puma { server unix:///var/www/myapp/shared/tmp/sockets/myapp-puma.sock; } server { listen 80; server_name myapp.com; root /var/www/myapp/current/public; access_log /var/www/myapp/current/log/access.log; error_log /...
Read more