Problem: Found 1 unknown column type conversion(s)

Asked By 7060 points N/A Posted on -
qa-featured

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

Found 1 unknown column type conversion

Problem: Found 1 unknown column type conversion(s) you are only allowed to save the package

SHARE
Answered By 20 points N/A #84983

Problem: Found 1 unknown column type conversion(s)

qa-featured

Hello Dominic

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!!
Thanks
Bennie

Login/Register to Answer

Related Questions