SQL Server Management Studio Express 2012

L.Jenkins · 2014-01-18 22:20:01

Downloaded the Express Management studio to run a database server for development purposes. I see it doesn't come with a Server Agent to run tasks. So running tasks will have to be done using other methods. With that, what would be the best way to run Integration Services through Visual Studio 2012?

18-01-2014 10:20PM

#1

L.Jenkins

Moderators, Computer Games Moderators, Technology & Internet Moderators Posts: 19,242 Mod ✭✭✭✭

Join Date: May 2009

Posts: 18488

Downloaded the Express Management studio to run a database server for development purposes. I see it doesn't come with a Server Agent to run tasks. So running tasks will have to be done using other methods.

With that, what would be the best way to run Integration Services through Visual Studio 2012?

0

Comments

#2 20-01-2014 12:25PM

stevenmu

Moderators, Society & Culture Moderators Posts: 9,688 Mod ✭✭✭✭

Join Date: July 2003

Posts: 9395

I think you can install SQL Server Data Tools to develop SSIS packages, but you would need a full or developer edition of SQL Server to deploy to. SSIS doesn't work with the Express editions AFAIK.

0
#3 20-01-2014 12:29PM

L.Jenkins

Moderators, Computer Games Moderators, Technology & Internet Moderators Posts: 19,242 Mod ✭✭✭✭

Join Date: May 2009

Posts: 18488

I half guessed it wouldn't work with Express.

0
#4 20-01-2014 02:12PM

stevenmu

Moderators, Society & Culture Moderators Posts: 9,688 Mod ✭✭✭✭

Join Date: July 2003

Posts: 9395

Yeah, it's a shame really, Express is a great product otherwise.

0