Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
crocboy25
Starting Member
1 Post |
 Posted - 2011-05-18 : 08:50:48
|
| Hello Group,I am trying to import some data from a sql server 2008 DB to another sql server 2008 DB on another server(from dev to test). A table has a column which is of type Geometry. I am using the Import/Export Wizard. At the point where it tries to execute my query, it errors out on the column that has the geometry data type. The error is below at the bottom. I tried adding the entry in the MappingFile(as also shown below) and it still throws the same error message. I added this entry on both the dev and test server. I could use some help as to what to do. Any advice? -- mapping entry -- <!-- 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>-- error----[Source Information]Source Location : tlhforsqldev01Source Provider : SQLNCLI10Table: [Query]Column: MR_MITIGATION_LATITUDE_LONGITUDEColumn Type: 204SSIS Type: (Type unknown ...)Mapping file (to SSIS type): C:\Program Files\Microsoft SQL Server\100\DTS\MappingFiles\MSSQLToSSIS10.XML[Destination Information]Destination Location : TLHFOR012Destination Provider : SQLNCLI10Table: [dbo].[mit]Column: MR_MITIGATION_LATITUDE_LONGITUDEColumn Type: 204SSIS Type: (Type unknown ...)Mapping file (to SSIS type): C:\Program Files\Microsoft SQL Server\100\DTS\MappingFiles\MSSQLToSSIS10.XML[Conversion Steps]Conversion unknown ...SSIS conversion file: C:\Program Files\Microsoft SQL Server\100\DTS\binn\DtwTypeConversion.xml |
|
|
|
|
|
Import Geometry Data in sql server 2008