Recommend using Script Component in the Data flow. The split function is normally faster than anything in T-SQL and less complicated than most other options.

Better late than never :w00t:

Here is an example;

DECLARE @DTSXML XML = N'<?xml version="1.0"?>

<DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts"

DTS:refId="Package"

DTS:CreationDate="11/7/2013 12:57:04 PM"

DTS:CreationName="SSIS.Package.3"

DTS:CreatorComputerName="USER-COMPUTER"

DTS:CreatorName="MyUserName"

DTS:DTSID="{10A38C50-3656-42E0-A054-87E8D9DFBD8A}"

DTS:ExecutableType="SSIS.Package.3"

...

A better way is to use the nodes method

http://technet.microsoft.com/en-us/library/ms188282.aspx

A good article on this: Ad-Hoc XML File Querying by Seth Delconte

https://www.simple-talk.com/content/article.aspx?article=1756

Could you provide the output of sp_help 'view', might shed some light on the problem.

Luis Cazares (3/21/2014)

---

Eirikur Eiriksson (3/21/2014)

---

Just a quick thought;

Splitting the string is somewhat like crossing the stream for a sip of water, when all that is needed is to get the...

Hi,

the string has to be parsed / split for this to work. Quick solution;

grab the splitter function from

http://www.sqlservercentral.com/articles/Tally+Table/72993/

IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = N'Customer' AND TABLE_SCHEMA =...

Two serious issues here,

the first is that the

@AcctType nvarchar

is only going to be one character in size;

DECLARE @getCnt int

DECLARE @AcctType nvarchar

SET @AcctType = 'ABC'

SELECT LEN(@AcctType)

CHLEN

1

The second is the...

Just a quick thought;

Splitting the string is somewhat like crossing the stream for a sip of water, when all that is needed is to get the position of the spaces/delimiters....

Got this one more or less ready, should be with you this weekend.

Do you mean something like the nitty-gritty of a schema collection and typed xml?

Hi,

the usage would be restricted to running R from a desktop using ODBC connections and Windows authentication. The users can access the same data...

Thank you Tomaz for this article.

stefan.lipiec (3/10/2014)

---

I have only scanned the article briefly and I would like say that please check the security implications of enabling xp_cmdshell with whoever is...

Just to point out a possible improvement on the first query in part 3.

The sql engine has to match all rows from the subquery to the outer query. This is...

Thank you Jonathan for this article.

Just a quick note on the last query, it will fail if a table is not in the default user schema.

This will work for...

My 2 cents: SQLCLR is like any other hammer, when you hold it, every thing looks like a nail! I think it is a valuable addition to the SQL Server...