Hi Gail,

Thanks for taking time to reply.

I have the timeout set to 60 seconds.

What is frustrating is that is works most of the time.

I will take your suggestions to increase...

Here is one example:

I am doing a BCP command from .NET Process.Start.

Sometimes I get this error:

TCP Provided: Timeout error

Sometime I get this error:

Named Pipes: Timeout error

Thanks

Grant,

Thanks for taking time to reply.

I have ordered your book.

Thanks

Tom

Hi Gail,

Thanks for your valuable information. You are the first DBA that is not surprised that there was no SQL error with this client exception.

Seems like I need to concentrate...

Hi Jeff,

Thanks for the good advice. I will change the "staging table" to have the same field types as the production table. Then I will check for errors...

I am using BCP to import the Flat file into a Table with ALL fields set to varchar(255) so there will be no validation errors during loading. Next, I...

Hi Luis,

Thanks for your reply. Are you talking about using BCP to import the flat file using the error file option? If not, can you...