You are a life saver... been using SSIS for years and always had a headache whenever I had to upload files to an SFTP location. Thank you so so much for simplifying this.
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?
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:password@sftp.example.com -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
use this code to get the most recent file from the folder and assign the value to an ssis variable. ua-cam.com/video/O1xVlKq8cqY/v-deo.html 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.
@@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
@@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.
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.
You are a life saver... been using SSIS for years and always had a headache whenever I had to upload files to an SFTP location.
Thank you so so much for simplifying this.
You are most welcome.
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?
Sorry, I don't have idea about creating md5sum.
thanks for all your explanations
Thank you Marina.
Hello, how do i upload a folder?
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:password@sftp.example.com -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
how we can upload the most recent file from our folder to Sftp?
use this code to get the most recent file from the folder and assign the value to an ssis variable.
ua-cam.com/video/O1xVlKq8cqY/v-deo.html
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.
@@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
@@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.
Hi Bro..how to use parameters in this script, I need to move the files only for specific month like filename_2024_05.xlsx
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.
Which OS is supported to SQL server 2012
learn.microsoft.com/en-us/troubleshoot/sql/general/use-sql-server-in-windows
Windows 10
But better to download SQL 2019
Saved my life😢
Its good to know that it was helpful for you.