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 note...

• This reply was modified 3 years, 9 months ago by frederico_fonseca.

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 on...

on your where clause - do WHERE Domain = @Domain AND convert(bigint, Filesize)  > 50000

I would also supply us with the code for that function you are calling as well as a actual explain plan for one of the executions - issue may well...

can you post the C# code you did - and can you explain in detail what the process is to get the files - is it multiple folders/files or single...

either install is to GAC (advisable but on  your server you will also need to install it in GAC) or use the assembly.resolve method - both explained on their page

download...

mostly no. some directory mask exist but not the way you need it https://winscp.net/eng/docs/file_mask#directory

you kind of always need to get a listing of files/folders on remote server onto a C#object...

and unlikely we will get any useful info of the OP - they just ask the question in multiple forums to see if they get any answer that may temporarily...

if your folder location varies it is a bit more complicated and you would be better off using the c# script route than using the execute process task (see https://winscp.net/eng/docs/library_ssis ...

• This reply was modified 3 years, 9 months ago by frederico_fonseca.

by reading the documentation for rs.exe you can.

also google is (as usual) your friend.

https://www.google.com/search?q=ssrs+rs.exe+delete+file&oq=ssrs+rs.exe+delete+file

https://stackoverflow.com/questions/26004172/deleting-multiple-ssrs-reports-across-subfolders-using-command-line

don't use SSIS for it - if the database is on same server just do a straight insert into it - if it is on a different server then use...

the index you were asked to supply is the one on table parts.tradecodecontrol -  index IDZ_ZPLID , not on  ExtractReports.dbo.TPls

the indexes that Des mentioned above would not help you as...

and winscp can be used within c# code - recommended way to use it  - https://winscp.net/eng/docs/library_ssis - or alternatively use it as a process task https://winscp.net/eng/docs/guide_ssis

shrink database is pointless - you do need to do shrinkfile but not using the option truncateonly as that will not move data around the file so it can free...

did you do a shrink database or a shrink file? looks like the first 1 and that is the wrong one to use