Man it goes down hill fast when posts are shorter than "short stories"

Oops, Sorry David , I was thinking of you while writing... never got to it because the thought of "timing out on post submit"...

Bill, I'm glad we all could help, even if we like to get off topic once in a while. Usually Frank's replies are right on the mark and helpfull. They will...

Mike,

It sure seems that way "explicit commit (inside the OpenRowSet)"... Seems very strange to me if this IS the case???? Still doen't explain why I get the same kind...

Shoot, I was writing a nice reply post, and lost it (timeout maybe??)

I get the same symptom on many of the servers here.

I use Q/A and either login as...

>> Does this make any sense?

Maybe a little ...

I do not see the "property date", you mention, in the SELECT statement you provided???...

So there is not way of getting a "return value" of the IDENTITY from the Winsock call you have to make. Right?

When you make the Winsock call, and it procedes...

Can you post, or Private Message me, the 1st few records of your file? May 1st 100 lines or so.

Make sure what you post produces a error/problem on your end...

I do the same sort of thing with back end produced text files, each file containing multiple tables.

1. Get each import table's data into #Temp tables in the fastest way...

Instead of

table1.name LIKE '%[table2.name]%'

Try

table1.name LIKE '%' + [table2.name] + '%'

Or optionally

table1.name LIKE '%' + RTRIM([table2.name]) + '%'

gljjr,

Thanks, I have to leave in a couple min., ....

How do I pass a blob > 8K as a parameter to SP?...

Allen, maybe instead of "VB Executing" your INSERT, call the "insert" in the form of a "record set" query returning your identity to be used as a constant in subsequent...

Check out row 15 (or 14,16 )  of your raw data for maybe a missing comma, or invalid QTY value.

I just cut & pasted...

Then I think Frank's idea of having 1 table hold results for multiple report requests is a solution. Otherwise, yout would have to make a unique named table, either permanent...

Will this little snipet help?:

Create Table Test1 (ID int IDENTITY (1, 1), Data1 varchar(10))

Create Table Test2 (ID2 int, Data2 varchar(10))

Insert Into Test1 (Data1) Select 'Data for 1'

Insert into...