N/APosted on - 03/05/2013
I am facing a problem, and I need help for this.
When I import spreadsheets in the SQL server wizard, its import successfully but when I try to combine these sheets an error comes which you can see at the below image.
Please help me regarding this
Problem: Found 1 unknown column type conversion(s) you are only allowed to save the package
Problem: Found 1 unknown column type conversion(s)
To solve this you have to manually define the mapping for geography and geometry data types.
To do so, you have to first get the conversion details by double clicking the row that contains the column source. When you will read that file, there would be a path given to XML file under "Mapping File"
Go to that path in your system and add the mapping definition.
The detailed information is given here at this link where you can also find the mapping information that has to be added in the XML file manually.
Go to this link here
I hope I helped!!