Problem: Found 1 unknown column type conversion(s)

Asked By anonymous 7060 points N/A Posted 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

• Status: Open
• Question Views: 4742
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Bennie S Easter 20 points N/A #84983

Problem: Found 1 unknown column type conversion(s)

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

About Bennie S Easter

Questions
34

Answers
41

Best Answers
8

• Vote Up 0 Vote Down

• Posted on - 03/25/2013
• Question Category: MS SQL Server