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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics