Import Flat file.. issue in SSMS Tasks

Question

Import Flat file.. issue in SSMS Tasks

Susja 756

Hello,

I was using Toad for a while but now I have to use SSMS.

I used Import Wizard in Toad to create a new table. It allowed me to overwrite existing table. In my case this was the most often scenario.

Now I started to use SSMS 'Import Flat file.. option but it rejects to overwrite and throws the message 'Provided table name already exists'.

Note: I have the same permission as before.

Is it 'design' of SSMS or I could trick some option to fix it for me?

Thanks

2 answers

Your answer

Answer 1

Susja 756

Thanks for replying

I think that creating a script would be the best for me

LiHongMSFT-4306 31,621 Reputation points

2023-06-14T05:36:42.1466667+00:00

If you have any questions, please feel free to share with us.

And don't forget to accept the answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread.

Thanks for your understanding!

Answer 2

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Share via

Import Flat file.. issue in SSMS Tasks

2 answers

Your answer