One more comment re Days_Retrieval...

The files will have a system generated timestamp.  Using this timestamp for calculating Days_Retrieval may not be helpful in all cases.  I will have to give...

Thank you so much for your help!

No problem.  Here you go.

The files are put on the SFTP site daily (M-F) and remain there for 30 days.  After 30 days, the...

I got C# working.  If the paths are explicitly set then no problem.  It works.  Now the next part is to use wildcards to access remote directory.  How would I...

I am trying to setup the C# approach.  The installation documentation isn't clear.  How exactly do you set it up?

Thanks for the reply.  I went with the Execute Process Task approach because it was way easier to setup.  I took a look at the C# one and I was...

wow!  so expensive.  pass!

I will code it as you suggested.

duplicate post.  sorry about that.

• This reply was modified 4 years, 1 months ago by water490.

Thanks for the reply.  I took a look at version.  Here is what I have installed.  I have VS 2019 and SQL Server 2019.  Does below show any version incompatibilities?

Microsoft...

The only thing now is... can you create 2 or 3 CLI calls to Filezilla that work for you and then change the login, password, and even the site...

No problem

I created the Power Query in Excel and then copied it to the Power Query task in SSIS.   I used the link you provided for the steps in...

Yes, that link...

Yes, that link should show...

perfect!

Thank you so much

thx.  it works

thank you everyone.  i will take a look at the suggestions.