One way of doing this is to add new columns to your underlying selection query, corresponding to your conditions.

The value of the column will be zero unless the condition is...

Not so strange, really.

Your original code was doing SET NOCOUNT ON if the condition was true and then reverting to normal execution.

Unless your if-statement code is of the form

if [condition]

begin

multiple...

starspejd (9/13/2011)

---

Hi Phil

I think I got it now. Granted, what I've made is only a small test on my own laptop, I still need to make the package on the...

No problem. Let us know how you get on and post back with any additional questions.

Those files with no extensions are a pain.

I'd be tempted to do this processing with a Windows batch file - here is one way:

1) Rename files with no extension (this...

Difficult to be sure without sample data.

First off, I do not recommend repeated use of SELECT INTO - you've got the overhead of deleting and rebuilding the table every time....

Why not just do a GROUP BY on all of the columns?

nairdeepa (9/9/2011)

---

I somehow managed to get to the stage that it creates tables taking dynamic variable name. But i am getting the below error. I have made the tables already...

kramaswamy (9/9/2011)

---

You might be able to pull it off if you used a Script Task as your Data Source, fed the object variable into the Script Task, and then parsed...

If you mean: "can I consume the contents of an object variable as a data flow datasource?" I believe that the answer is no.

There will be an alternative -...

Also ensure that the variable is of type 'Object' if you are capturing more than one row of data.

sqldba_newbie (9/8/2011)

---

I thought of the same that package would be...

This looks very much like the same question as was asked back in January on MSDN. See here for the full thread.

select ...

from vwSearchResult

where (len(COMPANY) - len(replace(COMPANY, 'ltd', '')) + len(CategoryName) - len(replace(CategoryName, 'ltd', '')) + len(comp_kws) - len(replace(comp_kws, 'ltd', '')) + len(locStr) - len(replace(locStr, 'ltd', ''))) > 0

GROUP BY ...

engrshafiq4 (9/7/2011)

---

Hi,

this is working fine for me.

select TOP 20 COMPANY,

len(COMPANY) - len(replace(COMPANY, 'piz', ''))

as numberofoccurences

from vwSearchResult order by numberofoccurences DESC

Can i do it for more...