How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Richard Your Own Question
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 37652
Experience:  Over 15 year experience resolving Microsoft Office Issues
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

I have a SSIS package which is generating excel file every

Customer Question

I have a SSIS package which is generating excel file every night, I need upload this file onto client secure ftp ,unfortunately SSIS not support sftp, so I need some .bat which will pickup the file and upload to sftp. I'm not familiar with dos command.I
have SQL Server 2008 R2 Thanks
Submitted: 2 years ago.
Category: Microsoft Office
Expert:  Richard replied 2 years ago.

Hi there and welcome

Best to use two files, you make one with the below text

open 21



binary put c\test.txt


save this as ftp.txt replace the IP after Open with your IP, and the username and password ***** well as c\test.txt to your path and file

And run it from the .bat file in the same file using the below command in that batch file:

ftp -s:ftp.txt


Then you run the batch file and it will upload your file

If you have any problems, or would like any additional information or assistance, please do not hesitate to let me know.

Else if you can take a second to rate my service by clicking one of the stars at the top of the screen then submit, that would be greatly appreciated.

Thank you