Thank you, guys, for all the input, I was off work because of the snow and the kids were home so I have not had a chance to read the...

There are no real bad speed issues at this time.   I am in the process of moving a bunch of data out of Microsoft Access and into SQL Server.   Some...

deleted

Hello, I realize that indexes are a big deal and have read up on them online a bit and in a book I have Wrox-beginning sql server 2012 programming (even...

I already checked the source files and they do not have a leading space.  I am already doing as you suggested on the access side but eventually I dont want...

• This reply was modified 2 years, 9 months ago by  railman.

Sorry, I don't know how the duplicate got created and could not find how to delete the post.    is there a sticky post or something that says how to...

Sorry for the late reply to this thread.  Hey Jeffrey, when you say better yet a gMSA account to run the services and proxy accounts what are you meaning?  I...

Update - After trying all kind of things I finally copied and pasted the full username NT Service\MSSQLSERVER and changed the location from the domain to the local computer and...

• This reply was modified 2 years, 10 months ago by  railman.

Ok, i created a view and was able to import the data into it using my stored procedure.

Next I created an Insert Into statement

Insert INTO FinalTracingImportSP

Select Initial, Number, [Location City],...

• This reply was modified 2 years, 10 months ago by  railman.

Thank you for the reply, I forgot to mention that i am very new to SQL server. I looked up how to create a view but I am not sure...

• This reply was modified 2 years, 10 months ago by  railman.

Genius, Thanks so much Federico_Fonseca.  That last edit did the trick.  I took 6 files from today in which I did no edits and ran the import and it imported...

I don't know if this matters but I deleted all the extra lines at the end of the file but with the last CRLF so there was one blank line...

First of all, please know I really appreciate the help I am being given on this.  Not only am I getting a problem worked on but I am learning a...

Hello, thank you very much for the help,  I implemented the change and as long as I dont have xact_abort on (i guess set it later once everything is working) ...

If I use LASTROW= 1001 and make sure that each file has at least 1001 rows (by putting in fake data) everything works fine.  The problem is I cant put...