dunn_Stephen (6/23/2015)

---

TITLE: Microsoft Visual Studio

------------------------------

Error at Data Flow Task [Derived Column 1 [45]]: Attempt to find the input column named "xmlMessage" failed with error code 0xC0010009. The input column specified was not found in the input column collection.

Error at Data Flow Task [Derived Column 1 [45]]: Attempt to parse the expression "SUBSTRING(xmlMessage,FINDSTRING(xmlMessage," < and > ;dateTime < and > ;",1) + LEN(" < and > ;dateTime < and > ;"),FINDSTRING(xmlMessage," < and > ;/dateTime",1) - (FINDSTRING(xmlMessage," < and > ;dateTime < and > ;",1) + LEN(" < and > ;dateTime < and > ;")))" failed and returned error code 0xC00470A2. The expression cannot be parsed. It might contain invalid elements or it might not be well-formed. There may also be an out-of-memory error.

Error at Data Flow Task [Derived Column 1 [45]]: Cannot parse the expression "SUBSTRING(xmlMessage,FINDSTRING(xmlMessage," < and > ;dateTime < and > ;",1) + LEN(" < and > ;dateTime < and > ;"),FINDSTRING(xmlMessage," < and > ;/dateTime",1) - (FINDSTRING(xmlMessage," < and > ;dateTime < and > ;",1) + LEN(" < and > ;dateTime < and > ;")))". The expression was not valid, or there is an out-of-memory error.

Error at Data Flow Task [Derived Column 1 [45]]: The expression "SUBSTRING(xmlMessage,FINDSTRING(xmlMessage," < and > ;dateTime < and > ;",1) + LEN(" < and > ;dateTime < and > ;"),FINDSTRING(xmlMessage," < and > ;/dateTime",1) - (FINDSTRING(xmlMessage," < and > ;dateTime < and > ;",1) + LEN(" < and > ;dateTime < and > ;")))" on "Derived Column 1.Outputs[Derived Column Output].Columns[Derived Column 1]" is not valid.

Error at Data Flow Task [Derived Column 1 [45]]: Failed to set property "Expression" on "Derived Column 1.Outputs[Derived Column Output].Columns[Derived Column 1]".

------------------------------

ADDITIONAL INFORMATION:

Exception from HRESULT: 0xC0204006 (Microsoft.SqlServer.DTSPipelineWrap)

------------------------------

BUTTONS:

OK

------------------------------