it's telling me now that the installation failed b/c an installation package for the product MS SQL Server Native client cannot be found. Try the installation again using a...

Also, why does it not allow me to install the instance on a different drive other than c:? (It's forcing me to install on c:)

Thanks. So I run this query every time I want to see if there are failed logins? Can't I just go to the error log directly to see...

SSCrazy,

Thanks, but where exactly do I put this code snippet?

Unfortuanatly I cannot upload the file, however the values are similar to this example:

This is what is in the text file:

12345

54678

90876

34205

In the table, after the bulk insert, it has the...

i've got the bracket or end-of-file issue resolved, however now I have this issue:

As stated previously, my bulk insert sp inserts records into a table from a txt file. ...

So the bracket is really invisible to the user? It's just something SQL knows somehow?

Thanks for your patience!

I'm sorry, I'm confused. My txt file does contain the square bracket on the last line, is this correct or not? If it is my bulk insert is reading...

But doesn't the bulk insert need that marker for the end of file?

The bulk insert, inserts records from a txt file. The txt file has the square bracket at the very end of the page/ or last record. Should that...

I see a square in the lost row inserted. It doesn't have any record information but for the square in the last row.

It is reading it in though.

I hope you can help me again. What if the sp reads in the end-of-file marker, how can I prevent that from happening?

I appreciate your help. It worked!

Thanks, what about checking for end of file?