153 How to upload files to sftp server using batch file in SSIS | WinScp

open sftp://hp:hello@192.185.0.521/ -hostkey="ssh-ed25519 255 SgbjGoUPs4JbLx4i5Vymcc7asasy1wpf/awTFcfWZvQ"
put "D:\Files\Apple\*.*" "/C:/SFTP Files/"
How to upload files to sftp server using batch file in SSIS | WinScp
drive.google.c...
SSIS Tutorials: • SSIS Tutorials
SSIS real time scenarios examples: • SSIS real time scenari...
SSIS Interview questions and answers: • SSIS Interview questio...
148 How to download files from sftp server using batch file / command line / ssis / WinScp: • 148 How to download fi...
How to set up an sftp server on windows 10: • How to set up an sftp ...
How to upload files to sftp server using batch file in SSIS
SFTP file transfer in SSIS
Uploading Files to SFTP Server using SSIS
How to transfer file to SFTP path using SSIS package?
How to upload file on SFTP server using batch script?
How do I upload files to SFTP server using WinSCP?
Happy Learning.
If you have any questions or suggestions please comment on the video or write to me at “[e-mail]”

[@Marina1BEL]

thanks for all your explanations

[@learnssis]

Thank you Marina.

[@shaarmineykrish3722]

Saved my life😢

[@learnssis]

Its good to know that it was helpful for you.

[@Pirate_Hunter_Zoro11x]

how we can upload the most recent file from our folder to Sftp?

[@learnssis]

use this code to get the most recent file from the folder and assign the value to an ssis variable. kzbin.info/www/bejne/hWLbh5-Bpp2Wp7s Now copy this file using file system task to a new folder locally. And then use the code shown in this video to upload the file from a folder.

[@Pirate_Hunter_Zoro11x]

@@learnssis brother could you please make a video on like one stored procedure which generate CSV file in a local folder and we have to send that latest file to SFTP folder

[@learnssis]

@@Pirate_Hunter_Zoro11x Here there are 2 things, exporting the csv file from stored procedure and then uploading the file from local folder to sftp server. I have made videos both of these items. You would need to run one after another.

[@tulasiramaallada2169]

Which OS is supported to SQL server 2012

[@learnssis]

learn.microsoft.com/en-us/troubleshoot/sql/general/use-sql-server-in-windows

[@gauravroy5802]

Windows 10

[@gauravroy5802]

But better to download SQL 2019

[@SaraNeiman]

I want to create md5sum for zipped files uploaded to Winscp, (After files uploaded to the server, then get a md5sum) I keep getting all types of errors. Is that something you can help with?

[@learnssis]

Sorry, I don't have idea about creating md5sum.

[@shahiransaleh1123]

Hello, how do i upload a folder?

[@learnssis]

Although I have not tried it but can you try this one, below command is used to upload the folder to sftp, got this command from chatgpt. put -r folder_name open sftp://username:[e-mail] -hostkey="ssh-rsa 2048 xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx" lcd C:\local\directory cd /remote/directory put -r folder_name exit

[@sekharkarumanchi912]

Hi Bro..how to use parameters in this script, I need to move the files only for specific month like filename_2024_05.xlsx

[@learnssis]

Hi Shekhar, I have not tried parameters with it, maybe I need to test that first, for now you can move the files to upload to sftp to a new folder using file system task and then provide the path of that new folder in the batch file.