Error inserting data into table with a column of type 'geography'
Hello,
I am trying to insert data into a table with a column of type 'geography' using a DFT with an OLEDB Source and OLEDB Destination. The geography column has a value of blank ('').
The SSIS just fails with the following error:
Error: 0xC0202009 at Data Flow Task, OLE DB Destination [16]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "A .NET Framework error occurred during execution of user-defined routine or aggregate "geography":
System.FormatException: 24112: The well-known text (WKT) input is empty. To input an empty instance, specify an empty instance of one of the following types: Point, LineString, Polygon, MultiPoint, MultiLineString, MultiPolygon, or GeometryCollection.
System.FormatException:
at Microsoft.SqlServer.Types.OpenGisWktReader..ctor(SqlChars chars, GeoDataSink sink)
at Microsoft.SqlServer.Types.SqlGeography.GeographyFromText(OpenGisType type, SqlChars taggedText, Int32 srid)
at Microsoft.SqlServer.Types.SqlGeography.Parse(SqlString s)
.".
Can someone throw some light on when does one encounter this error and how to resolve it?
Thanks,
KK
January 29th, 2011 8:20pm