It depends.

If the date is always at the same position, you could use SUBSTRING to eliminate it. Otherwise you'd need to find the pipe character and move left.

As a side...

Craig Farrell (1/25/2011)

LutzM (1/25/2011)

When using the same tool: London sounds much more reasonable 😉

Side note: interesting...

When using the same tool: London sounds much more reasonable 😉

Side note: interesting web site...

Tunis? Algier? Edit: at lest when using Bing maps...

The current discussion actually provide some answers "someone" might need for a meeting in the near future.

The question this person has to answer: "What systems are affected and what changes...

@matt-2:

You're not talking about the free trial version to design the XSD schema for using it with SSIS, do you? 😛

duplicate post.

Continue discussion here.

Here's an example:

DECLARE @xml XML

DECLARE @xml2 XML

SELECT @xml='

<Person>

<Name ID="1" First="John" Last="Doe">

<email>1@a.com</email>

<email>2@b.com</email>

</Name>

</Person>'

SELECT @xml2='

<Person>

<Name ID="1" First="John" Last="Doe">

<email>1@a.com</email>

</Name>

<Name ID="1" First="John" Last="Doe">

<email>2@b.com</email>

</Name>

</Person>'

SELECT @xml,@xml2

You can shred it so you have one table with on or...

Since there are multiple way to present data in an XML format based on the same relational schema I don't think the tools provided by SSSIS are sufficient enough to...

Your sample data and your expected output don't match.

Please try to describe more detailed what you're trying to achieve.

One way of doing it would be to create some sample data...

Here's something to get you started.

Step 1 is to transform the denormalized table back into a normalized structure. Since we already touching each and every row multiple times we can...

Please show us what you've tried so far and where you get stuck.

Your request sounds like we're supposed to code it for you. That's called consulting.

The most important question: Are you using SQL Server 2005 (as indicated in the header) or SS2000 (as per the forum you posted in)? Makes a huge difference...

You might also...

What exactly is your question?

A little more information will certainly help... E.g. posting your expected result based on your sample data including some info whether you want to have it...

igngua (1/21/2011)

thanks it...