My thought is that you'll need to break this question down to smaller chunks, quite a large ask here!

😎

Having assessed the information you posted (and more importantly what is not...

Quick question, how many rows are in the table?

😎

Given the numbers, you would be much better off doing a backup onto a USB stick, walk over to the other server...

Guess someone is RTFM'ing 😉

;cool:

Couple of questions:

1. Did you run the setup as an Administrator?

2. What are the privileges of the account running the SQL Server Service?

😎

As a side note, I would prefer to...

Just a quick question, what are the variations of the values in the first four columns?

😎

You are trying to create a table with 1000 columns that exceeds the maximum 8060 page's byte limit!

😎

Conclusion: Redesign 😉

Just a thought, start by importing the file as all character columns, then analyse the data and reconstruct the target table.

😎

I don't like the Import AND Export Wizard, pretty daft...

Add a try-catch with error reporting in the inner procedure

😎

one of those I refuse to help now - ignores suggestions and fails to supply requested information and...

one of those I refuse to help now - ignores suggestions and fails to supply requested information and just wishes...

My observation on your question is that it is time to call a consultant 😉

😎

Last time I did a similar thing, it took code in excess of 1000 lines and...

Just a thought, closing old inactive would be a good thing, after a year most activities are either spam or should be posted as a new thread.

😎

• This reply was modified 3 years, 10 months ago by Eirikur Eiriksson.

10001? That would be 17 in...

>>>>Eirikur Eiriksson wrote: >>>Grant Fritchey wrote:

>>Sean Lange wrote:

>And in other news....I have taken the plunge. After almost 25 years as a developer I have just accepted a new...

And in other news....I have taken the plunge. After almost 25 years as a developer I have just accepted a new position as a full time DBA. Even...