Was expecting some reference to support. Still not sure about the answer.

Thanks,

I wish Joseph speedy recover. Inspiring article.

I completely agree with the fact that stored proc with the prefix "sp_" is reserved for system stored procs. However, the 2nd part is not correct.

If a...

Very much useful article. Thanks

I've chosen for nchar(1) because it only says that the value won't be NULL or empty, but there's no limitation on the characters used.

Thanx, This has met my requirement.

Thanks Again,

Ashesh

Thanx for the response. The FIRSTROW option can be used along with the format file only.

Ashesh

In this particular case DTS package cann't be used. Still I would like to the way.

Thanks,

Ashesh

I tried to delete this particular post. But failed.

Sorry for the inconvenience.

Thanks,

Ashesh

Hi All!

Thanks a lot for the response. This is really a nice turn around for capturing the error. I think this will help me a lot.

Thanks again

Ashesh

Hi!

Thanks for the response. I've already scanned thru BOL & tried to get something from net in this issue. The BOL section which you have mentioned works verywell when delimiter...