You mean Source and destination both are SQL SERVER ?

Hi Dude,

I need to make this in to single SQL statement without updation.

Thanks folks it got executed.....

Sorry for the late reply.

Hi Buddy,

I tried your query but i'm getting Syntax error as

Incorrect syntax near the keyword 'IN'.

Please help on this.

Thanks buddies..

I will check and let u know.

Hi Phil,

Thanks for checking my query.

Can you please let me know where i need to do changes.

Thank you.

Hi Buddy,

Its deploying to the Sql server.

Yes, i have some updates done in the new package.

Thanks Gilamonster

Any General Example.....

Hey,

Can you give one example ?

Hi Luis,

Can you just give me an idea of how can we create.... as iam newbie into this.... and i got this to do as an assignment .... please help...

Ohhh okiees... so i dont know that

Yes you can do it using Shared Data Source..... by creating the connection for the first time....and for every 2nd report just give the Shared data source.....

That's it simple...!!!