June 24, 2015 at 7:53 am
Hi everyone I am trying to figure out how to parse a specific string od fata out of a column in ssis into another new column with findstring and substring.
FINDSTRING(XMLMessage,"<dateTime>",1) != 0 ? (SUBSTRING(XMLMessage,1,FINDSTRING(XMLMessage,"<dateTime>",10) - 19)) : XMLMessage
I need to search through the string in the column XMLMessage and find"<datteTime>" start at 10 characters and take 19 from the column inbto a new column. I need some syntax help with this ssis column import
June 24, 2015 at 7:55 am
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 xsi:type="ErrorResponseData"><errorCategory>Security</errorCategory><errorCode>50224</errorCode><errorMessage>Access denied. Missing NAME parameter.</errorMessage></data></messageResponse></RequestResult></RequestResponse></soap:Body></soap:Envelope>
June 24, 2015 at 8:29 am
This is a duplicate post. There are answers, maybe not adequate ones, here, http://www.sqlservercentral.com/Forums/FindPost1696979.aspx. Please put new answers there so the thread stays together.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply