well this is my manager requirement, he want to track the jobs record from that table, if he need an information of one month ago then it would be easy...

ya i mean to create a container inside control flow, in control flow tab, execute sql task is connected with data flow task, so if we put those two tasks...

Is there any way we can create a container and would be able to do with a single data flow task,

dave

Just to make u easier, i have one data flow task on control flow, and if you double click that data flow task, there are 10 tasks inside data flow...

yes each data load have its own data flow task, for your convinence I have 10 data flow task on data flow tab, on control tab I have one execute...

how do i add aspnet user and what password i need to provide while createing aspnet user, in one of my server i see aspnet user where reportisn service runs...

if i rerun the setup it says reporting server is already installed, and asp.net 2.0 version is already installed. I have no idea what to do now

I see report and reporttempdb on my database engine, but didnt see reprtserverdb. what about aspnet user, do we need to create that user also

Intresting part is that aspnet user is not created in a machine, in my knowledge when we intall reporting services, aspnet user supposed to be created on machine, right?

I did check the reporting configuration manager,i dont know how to configure it, web service identity and database setup are red.

seems to be working now, thank you very much 😛

appriciated

u mean i just need add that expression.on email task presedence?

yes i need email when ever error occurs and dont need email when there are no errors at alll. In thisi condition (495) errors yes i need an email becuase...

I got your point, but my fault I couldnt explain you clearly what I am doing, let me explain agan, I need to create a package which will write an...

what expression do i need to add? i am bit confused because we tried with too many expressions.