Now you're looking for a patternmatcher, which in this case would entail using CLR Regex.

LutzM (8/26/2011)

---

FreeHansje (8/26/2011)

---

So, the use of PERCENT is the problem? That's the only difference I notice...

Tnx for the heads-up all. I rarely use view design, but I was lazy this...

Well - some of the nice features of interest to a data guy like yourself:

- strong-typing facilitiies using schemas and namespacing. Not only do I get the data...

SJTerrill (8/24/2011)

---

As a side bar... I'm truly disappointed in XML in general. I thought the whole purpose of transmitting tags was so that you'd automatically "know" what's in the...

umailedit (8/23/2011)

---

However, some years ago you could get 4 or more people for the price of one Swede and now you get maybe 3 or less. In China the salaries...

GSquared (8/19/2011)

---

Please don't remind me of that!

I recently had to rebuild an SSIS package that had 6 child packages, each of which used multiple child packages, some of which also...

GSquared (8/19/2011)

---

Jeff Moden (8/18/2011)

---

@Gus,

Dang... I knew there was something else I wanted to ask and forgot it for a moment. If it's not obvious that I'm no SSIS-Ninja, let...

BW_Toro (8/17/2011)

---

Matt Miller (#4) (8/17/2011)

---

Well the short answer is - its primary purpose isn't speed copies "as is" of data. There is a way to perform bulk-loading operations ,...

Well the short answer is - its primary purpose isn't speed copies "as is" of data. There is a way to perform bulk-loading operations , but it's an awfully...

While they did make some improvements to how it operates (the fact that you can in fact disable it is very good) - I still don't understand why they keep...

Informatica is very popular in a lot of high-end ETL projects. It's often touted as one of the top performers in terms of functionality and performance.

That said - it's...

Well - to some degree.

I don't care for the bloat either, but you're paying for the portability and the self-describing aspects of the data. I do know...

Actually - there's one more SSIS option. Create the select as a stored procedure, and call it from an Execute SQL parameter. Capture the output as an OBJECT,...

Then your next best option would be to use a procedural language to represent the data hierarchy in a big...

one way is to get rid of the Insert @myXML line of your command and then follow the tips on this link:

http://blogs.msdn.com/b/jenss/archive/2009/11/06/an-secret-ssis-xml-destination-provider-you-might-not-found-yet.aspx