Curious - why do you need to create a script task and execute a SQL query in that script task?  If this is a one-time call to get/set some...

Thank you so much!  It works as planned.

One more question ...

From a design perspective... is it better to have one script do it all or should there be different SSIS tasks for each?

try the following - just an example and you will need to play with destination filename/directory

its only the using session block - no need to post the remaining code

do...

Thanks for the info. I'll play around with it.

could you advise how do you know which files have been processed - and do you keep a copy of them...

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 3 years, 7 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...