Thank you for the reply.

Yes I mean column titles.  That is what I mean by "headers".  Sorry for the confusion.  Looks like dynamic SQL is a possibility.  No clue how...

Thank you for your reply.  I appreciate it.

I ended up re-doing the work and it is working now.  No clue what happened to the original version but it is ok. ...

thanks for the reply.

no such thing as dumb/silly question!  🙂

I haven't done anything different.  VS2019 keeps track of which package was opened and I have always been picking the one...

there is no such thing as a dumb question.

it is sql server 2019:

I downloaded and installed it.  Still not working.

What else do you suggest I try?

I am rookie but I am very interested in learning what the pros do so my coding experience and code quality improves.  I have been doing some reading on gitlab. ...

My current attempt at source control is quite basic.  I use Task -> Generate Scripts and save the script file.  This way I have a snapshot of all tables, SP,...

I like the idea of source control.  Makes sense.   I prefer an on-prem solution vs github etc.  Can I do this in SS?  Or do I need an external program? ...

Actually...I ended up moving them manually.  No need for code.

i used Ken's solution.  works great!

i just tried the clustered index approach.  it worked.  thank you for this!!

• This reply was modified 2 months, 1 week ago by water490.

thank you both.  the code is working great now.

Thank you both.  The line numbers got added.  I ran the BULK INSERT code and the entire text file got added to one row vs separate rows.  I don't think...

• This reply was modified 2 months, 1 week ago by water490.

it won't let me post the formatfile so here is a picture of it:

Not sure what is going on here.  I posted a reply twice but it never got posted.  I will try again.  Sorry for any spam.

I did some research and it...