Hi,

Are you looking to consume web service (reporting Service) by an asp.net page and expose reports directly from reporting server.

Have a look at this piece of code.

Add a web Reference...

Thanks !

I think you referred to the thread and forgot to pate the link...can you post it ?

Hi,

You need create a TASK at the starting point of the Package and name it as Truncate Task and this should be Execute SQL TASK and command should be TRUNCATE...

HI,

http://www.sqlservercentral.com/articles/Integration+Services/61621/

You can refer this article.

Also for your source , use XML Taks - Last Item in Control Flow Items.