Error during the import and export in SQL 2008

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

Recently I was working on copying a database containing UK Postcodes and their associated geo-location data to one more SQL 2008 server.

The chart restricted a listing of all UK Postcodes along with their longitude and latitude and a Geo Location column that was based on the new SQL 2008 Data Type Geography.

On trying to use the Import/Export wizard to copy the data I had to do the Review Data Type Mapping page and was faced with the error message as follows:

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

What am I missing? Please help.

SHARE
Answered By 55 points N/A #114425

Error during the import and export in SQL 2008

qa-featured

This is a common problem and you can find the solution to it anywhere. So I will just narrow it down for you so that you don't have to do the search stuff. Just follow these steps and see if you can get over the problem.

First of all, try switching over to SSIS BID in SQL R2 because it works for most of the people. Try this and if it works then leave the rest. If it doesn't then proceed.

Edit the following two files that are located in the installation directory of the SQL server. You can find it in program files, SQL server, 110, DTS, Mapping files,MSSLTOSSISS10. it can be in two places if you have the 64bit version of windows. 1 in program files and other in program files(x86)

Add the following code


<!– geography –>
<dtm:DataTypeMapping >
<dtm:SourceDataType>
<dtm:DataTypeName>geography</dtm:DataTypeName>
</dtm:SourceDataType>
<dtm:DestinationDataType>
<dtm:SimpleType>
<dtm:DataTypeName>DT_IMAGE</dtm:DataTypeName>
</dtm:SimpleType>
</dtm:DestinationDataType>
</dtm:DataTypeMapping>   

And, if you want to support geometry as well, you may as well add the following while you're there:

<!– geometry –>
<dtm:DataTypeMapping >
<dtm:SourceDataType>
<dtm:DataTypeName>geometry</dtm:DataTypeName>
</dtm:SourceDataType>
<dtm:DestinationDataType>
<dtm:SimpleType>
<dtm:DataTypeName>DT_IMAGE</dtm:DataTypeName>
</dtm:SimpleType>
</dtm:DestinationDataType>
</dtm:DataTypeMapping> 

Related Questions