You can use:

=IIF(IsNothing((First(Fields!SystemID.Value, "DataSet_M"))), "No Data Found", Nothing)

I'm not positive i have all the parenthesis right, but IsNothing is the function you are looking for.

Parameter sniffing won't cause the results...

Jonathan Kehayias has a query in this blog post[/url] that finds parallel plans in the cache so you could compare your results to his.

Oh, also, it could be that you...

It's really hard to tell what could be the problem with all the data type manipulation being done in the query.

My first thought is that it doesn't have anything to...

The biggest issue I've seen with using views is that sometimes a view may be accessing tables not needed for the results for that specific query or doing other operations...

waxb18 (5/2/2014)

Thanks for the suggestion and the advice.

I have taken a look at the splitter and it works very well.

However the purpose of this exercise is for my...

I believe the pattern I have proposed will outperform the pattern you have proposed. My proposal only makes one pass at the data while yours makes multiple passes and...

One thing you could do is just use a SELECT DISTINCT when transferring the data, but if you want to remove duplicates I'd suggest this:

WITH deDupe

...

You can do this to get the plan:

SELECT

DEQP.query_plan

FROM

sys.dm_exec_query_stats AS DEQS

CROSS APPLY sys.dm_exec_query_plan(DEQS.plan_handle) AS DEQP

WHERE

[some...

You can use external assemblies in SSIS Script Tasks and Components but they have to be strong-named and in the GAC. Here are a couple of older blog posts...

That's your answer, just replace the hard-coded text with your Field name.

Is this a one time process or something that will reoccur? If it is a one time process the business will probably be better off entering the data by...

I'm pretty sure you could use Jeff Moden's DelimitedSplit8K[/url] function using CROSS APPLY. Something like this:

SELECT

P.project AS jobnumber,

S.item AS customer

FROM

...

I'm pretty sure the pattern I provided in my first answer will do what you need. Just replace the made up object names with the names of your tables...

If you could set up some test data like I did and provide the expected results form the test data someone may come up with an answer. Right now...