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, 8 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

same issue - no emails and toolbar gone

this is the 4th thread you create on the same subject - if no one has answered the other 3 then creating a new one is not going to sort...

Good SQL programmers do not use proprietary features like TOP in their code. If your system lives for a few years, there's a good chance it will be moved...

once you add the parameter you can't add it again - but you can update it.

so on your last example where you have the case block you need to instead...

your most welcome and it was no bother at all to help on this.

and we all learn something everyday mainly when we help others.