Actually I am on 2008. I just asked the question on the first SQL forum that I found. Did I post in the wrong place?

Wow. I didnt catch that. Thanks for the help. Works like a charm.

http://www.sqlservercentral.com/Forums/Attachment17609.aspx

Sorry its been awhile. this is how I solved my problem. I used SUBSTRING AND FINDSTRING with a logical operator to search for the opening and closing tags of the...

Here is a sample of the information in that column as a blob of data.

<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><RequestResponse xmlns="http://questionmark.com/BESTT/"><RequestResult><messageResponse xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns=""><header><version>1.0</version><messageID>09823ab8d085e0ac0301690ef750334854cd1476ec3b94454004b565d2f1f9df</messageID><login>0</login><progress>0</progress><customerID>NGQMRepository</customerID><lang>en-US</lang><licenseText>Questionmark Perception licensed to USMC</licenseText><authentication>Unknown</authentication><entryPoint /><settings /><dateTime>2015-04-30T20:39:27.6669106-04:00</dateTime><branched>false</branched></header><action>Error</action><data...

No help here hu?

Error: 0xC0049067 at Data Flow Task, Derived Column 2 [12]: An error occurred while evaluating the function.

Error: 0xC0209029 at Data Flow Task, Derived Column 2 [12]: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR....

Thank you for your assistance. I look forward to your response. SSIS isn't difficult its just got a lot of features and a lot of functionality. Some of the syntax...

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...

Doesn't like it. Says the syntax is incorrect

Here is a sample of the information in that column as a blob of data.

<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><RequestResponse xmlns="http://questionmark.com/BESTT/"><RequestResult><messageResponse xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns=""><header><version>1.0</version><messageID>09823ab8d085e0ac0301690ef750334854cd1476ec3b94454004b565d2f1f9df</messageID><login>0</login><progress>0</progress><customerID>NGQMRepository</customerID><lang>en-US</lang><licenseText>Questionmark Perception licensed to USMC</licenseText><authentication>Unknown</authentication><entryPoint /><settings /><dateTime>2015-04-30T20:39:27.6669106-04:00</dateTime><branched>false</branched></header><action>Error</action><data...

I have a file that looks like this:

2015-04-30 23:34:43:9277,PRODMILQMP-TR,PRODMILQMP-TR$,QM.Perception.Delivery.Service,"Request message XML:

<messageRequest xmlns='http://questionmark.com/BESTT/'><header><version>1.0</version><messageID>6760f33cd2de5ef4e06e1bd8f4f9f0047f58c5a6e7adc0affff61f8baa57e056</messageID><authentication>pip</authentication><login>0</login><progress>0</progress><customerID></customerID><lang>en-US</lang><settings><logSettings version='853' /><presentationTierSettings version='2912' /><fileUploadSettings version='252' /><browserCheckSettings version='582' /></settings></header><action>StartAssessmentDirect</action><data schema='HTTP'><header id='HTTP_USER_AGENT'><![CDATA[Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0;...

http://www.sqlservercentral.com/Forums/Attachment17328.aspx

Ok. Thanks. I will revise and work on smaller pieces and get back to the forum. Thanks.

Actually should have looked more like this.

Insert INTO dbo.QABSNew(

[logTime],

[fromServer],

[toServer],

[service],

[messageId],

[filePath])

SELECT T.logTime, T.filePath, T.fromServer, T.toServer, T.service, T.messageId

FROM QABSNew T

LEFT JOIN temp_LogImporter E on T.logTime = E.logTime

WHERE...