SQL Server Home
SQL Import Wizard - Edit Mappings... Drop and re-create destination table
as Won't Fix
9/13/2007 8:12:39 PM
User(s) can reproduce this bug
The enabled/disabled property of option "Drop and re-create destination table" is the reverse of what it should be.
The problem is similar to FeedbackID=272764
Also reported here: http://www.mydatabasesupport.com/forums/sqlserver-dts/184266-drop-re-create-destination-table.html
SQL Server 2005 SP2 - Standard Edition
Tools (SSMS, Agent, Profiler, etc.)
Win2003 Standard Server (SP2)
Operating System Language
Steps to Reproduce
- Import data from an external source using the SQL Server Import and Export Wizard.
- When you get to the step Select Source Tables and Views, tick any row then click button "Edit Mappings..."
- If the destination table exists the option "Drop and re-create destination table" is disabled. Weird!
- The in the reverse situation (ie. table does not exist) the option "Drop and re-create destination table" is enabled. How can you drop a table that doesn't exist?
The enabled/disabled property is the reverse of what it should be.
The option "Drop and re-create destination table" should be enabled when the destination table exists.
Or, to put it another way:
The option "Drop and re-create destination table" should be enabled when the option "Create destination table" is disabled.
to post a comment.
Please enter a comment.
on 4/9/2008 at 2:01 PM
Thank you for using our product and providing feedback!
We evaluated your suggestion. We will probably revisit it in the next release.
Thanks again for your time and valuable feedback!
to post a workaround.
Please enter a workaround.
© 2014 Microsoft