February 9, 2017 at 7:44 am
Hi guys,
If possible, can anyone provide an example of using an SFTP task in SSIS?
I have downloaded Cozyroc, which gives me the ability to have an SSH connection.
What I need to better understand is how to move multiple excel files(which are located in the different subfolders) from the remote location to an archive share folder when the files are greater
than 30 days.
Your insight is greatly appreciated.
February 9, 2017 at 6:01 pm
Check out the documentation:
http://www.cozyroc.com/ssis/sftp-task
February 10, 2017 at 7:40 am
Joe Torre - Thursday, February 9, 2017 6:01 PM
Thank you for the link.
I was able to make progress with my package.
I need some insight on the remote filter. I'm not familiar with C sharp coding and need to know how I would rewrite the below code to receive files that >=180 days old? The below code gives me between now and 30 days old files, but I need only >= to 180.
Modifiedtime >Now.AddDays(-30) and Name.EndsWith(".txt")
February 10, 2017 at 9:28 am
Post your code
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply