Maybe try something like

Isnull([Month 01]) && Isnull([Month 02]) etc

Also, for future info, I've reformatted this (thanks Redgate, but there are free alternatives) and put it in tags. See how much easier it is to read:

select count(tvid)

...

Using your code, adapted slightly:

declare @StartDate date = '20130501'

--Wednesday

declare @EndDate date = '20130507'

...

var05 (5/29/2013)

---

Ya you are right... List of ids to be pulled from one table and pass it to a query as a filter...

The problem is both the tables dont reside...

var05 (5/29/2013)

---

Thanks both!

Say I have a table in SQL where in I add and remove the employee names.

My Execute sql task will pick up the employees in that ABC sql...

var05 (5/29/2013)

---

Hi All

I would like to know how to pass a paramater from Execute SQL task to OLE DB source

I have an execute sql task returing a full result query....

Put both result sets in database tables and run some queries so that you can understand what the extra rows look like. Then, maybe, you can...

KoldCoffee (5/28/2013)

---

Phil, you've always been spot on for me in the past, so I was :w00t: and :ermm: and :crazy:. and a little bit wondering if it had more to...

KoldCoffee (5/28/2013)

---

Phil, I don't get what you're saying. How would a Lookup table help me in a situation where I need to derive new values in the source table based...

Shree-903371 (5/28/2013)

---

I set nocount on and it is displaying the results. Before it used to not export any data. I sed the below script in my ssis package and it...

The syntax for the derived column gets difficult to maintain doing it this way, as more lookups are added.

An alternative is to use a lookup table - either physical or...

Jeff Moden (5/27/2013)

---

Phil Parkin (5/27/2013)

---

This looks like bread and butter for an asynchronous Script Component to me.

Here's a link that should get you started.

The 'asynchronous' part here refers to the...

This looks like bread and butter for an asynchronous Script Component to me.

Here's a link that should get you started.

The 'asynchronous' part here refers to the fact that the number...

As far as I know, single procs which can return different result sets are not supported until SSIS 2012, where you can use the WITH RESULT SETS hint when calling...

You seem to create a temp table called #ID, then INSERT and SELECT from #EID, which is not defined. Have you missed out a section from your code?

Can you possibly...