Really?  What was good about this thread?  I could be wrong but  I'm thinking that you're just doing a SPAM test.  If I am...

and do all tables contain identity columns?

if so  you could look at restoring your db, take note of the values for all tables, set the identity to a higher value...

You mean a...

only really required if you have single tables that go...

that happens a lot and sometimes without any explanation.

copy the remote file locally, change it as required and then copy it back to destination.

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 3 years, 8 months ago by frederico_fonseca.
• This reply was modified 3 years, 8 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 3 years, 8 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...