Schedule SSIS Package in Visual Studio

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

Schedule SSIS Package in Visual Studio

Author

Topic

Les.61
Starting Member

49 Posts

Posted - 2010-03-25 : 23:24:50

I have created a SSIS package in Visual Studio but I cannot find how to schedule it. I would normally do this in Management Studio however we are looking at moving our server and will only have Visual Studio access and not Management Studio access.

We aer running Visual Studio 2005

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-25 : 23:29:19

As far as I know, Visual Studio does not have a scheduler like SQL Server does. It's not really Management Studio that has the scheduler, it just has a GUI to the SQL Server scheduler, aka the Agent.

If you don't have the Agnet then you can use Windows Task Scheduler to schedule your package. It comes with the Windows operating system.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Les.61
Starting Member

49 Posts

Posted - 2010-03-25 : 23:54:13

Tara

Thanks for the info but when I try that it opens the packahge but I still need to manually 'execute' and then close the result window. Any solution?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-26 : 11:55:13

I don't understand what you did.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-03-26 : 13:56:25

see this article http://msdn.microsoft.com/en-us/library/ms182079.aspx as well as the links referenced at the bottom

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-03-27 : 03:41:39

quote:
Originally posted by Les.61

I have created a SSIS package in Visual Studio but I cannot find how to schedule it. I would normally do this in Management Studio however we are looking at moving our server and will only have Visual Studio access and not Management Studio access.

We aer running Visual Studio 2005

then deploy package to server and do scheduling there from sql server agent

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources