Thank you so much!!

It is really interesting how the two approaches are very different (Import Data vs Bulk Insert).  That column you mentioned has never been a problem when...

the bulk insert options you used were just a sample - you needed to adjust to your own needs.

you also can't have extra columns on the destination table - if...

• This reply was modified 4 years, 5 months ago by frederico_fonseca.
• This reply was modified 4 years, 5 months ago by frederico_fonseca.

can you give us a sample file?

If I couldn't keep every file in a local folder - so that I could use a simple File.Exists() in C# to determine if the file has already been...

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

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 4 years, 6 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 4 years, 6 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