I have created a package in ssis and i need to schedule it every week. How do i do that since i found out that there is no sql server agent in 2008r2 express edition.
My understanding is that you'll need to install Integration Services to be able to do this - and that Integration Services is not part of SQL Server Express (except in skeleton form to support the Import/Export Wizard).
So I don't think you'll be able to do this.
Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.