December 4, 2013 at 3:37 am
Hi,
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.
Please help.
December 4, 2013 at 3:47 am
suchitra.venkataramani (12/4/2013)
Hi,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.
Please help.
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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
December 11, 2013 at 11:41 pm
You should not have SQL Agent for SQL Express edition, so you should not create a job and schedule..
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply