You're welcome...

Not sure what it is but being called "dear" instead of "Jeff" kinda bugs me, especially if you're a guy... must be a language barrier thing

So... post the actual name of the column that identifies individuals along with a bit of sample data for those, the actual names of the other two columns, the datatypes...

<Psssst!  Bulk Insert...>

BULK INSERT dbname.dbowner.tablename  

FROM '\\machinename\path\Sample.csv'

   WITH

      (

         FIELDTERMINATOR = ',',

         ROWTERMINATOR   = '\n',

         FIRSTROW        = 2,

         ROWS_PER_BATCH  = 50000 

      )

No need for format files or anything else...

PLEASE, don't double post...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=380596

Lookup "Expanding Hierarchies" in Books Online.

And, if you search this site for "Hierarchy", you'll also find some pretty decent procs/functions for this.  If you come across any that use recurrsion,...

Heh... I think lots of folks, including me, have made that error at least once

Just a bit of an edge for performance...

You do NOT need a cursor to do this... but I need a bit more information...

1. Are you the only person who will store this type of data in the database?
2. Why...

Dave,

If you want to do this from an app or even TSQL itself, see the following script for how to do it... and, yes, it is a registry change...

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1854

I guess I just don't understand why you are using OpenRowSet when Bulk Insert will load the file in about two heart beats.  You wanna try that, instead?  Lemme know...

Could it be that the sender of the files is sending the trigger file before the data file is received in total?

Spot on, Michael

Why wouldn't someone just use Bulk Insert on this one?

How in the heck does RA3 equate to an RBO of 4000???  And, what is the primary key of the table?  We need some more info on this one, for...

Yes... I've changed my stance on XML, Frederick.  I hate it even more simply because of it's similarity to bloat-ware... but, the folks in OPS just love what it does...

Other guesses might be that someone opened the file to see if the FTP was done or a system defrag was running.