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...

Nah, I'm looking forward to your next thread: "would Jesus have made a good database...

Bhaskar.Shetty (5/24/2013)

---

Please reread my post. Use a dictionary, if necessary, to help you understand its meaning. I did not call anyone silly. I said that the post made you look...