wow..that's the first good info i have seen..thanks

But I couldn't figure out if we have to check these in or not. Any ideas?

Thanks Elliott..sorry fo the delay.

I have tried to get it to work but it wont budge!

Using a partial cache(with ot without the "modify sql"), the data flow just sits at...

thanks John

but if i add these new mappings in the lookup(begin and end date to lookup date), my lookup operation wouldn't work as expected...

Because i want to do the lookup...

Unfortunately even if i add those variables to the pipeline using a derived column component, i can use them in the lookup parameters only if they are used in a...

No, i am actually trying to add some columns...

yes u r right, i am storing only 1 row since i need to use only 3 specific values from my package variables for my lookup query.

As to the...

Thanks for the reply Elliott.

1. I have 3 connection managers in my package. All refer to the same server.

2. I create the temp table using an Execute SQL task using...

Thanks for the reply.

I actually found a really good blog at http://blogs.conchango.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspx, which explains the solution to my exact requirements.

Using event handlers at the package level, I dont have to...

I tried it out and it works perfectly! thanks.

I did not face any complications because all my select queries are the same..differing only in the table name..i.e. the columns and...

Thanks a lot Phil. That should work..by having a dummy select statement to generate the metadata.

Will try it out as soon as i get some time..priorities have kinda changed.

Thanks again

Thanks for the reply. That is a valid solution but unfortunately i have a constraint..I need to keep my SQL queries in the stored procedure itself because it contains a...

Thanks fo replying.

I am not trying any looping.

Even the resultset structure is the same for all the tables that i want to use as source. They only differ by the...

Thanks Luke! that worked perfectly! i moved "x" to the bottom of the report parameters list and deployed it. Now it shows the label always.

Although x does not depend on...