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.
| 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 |
|
|
Les.61
Starting Member
49 Posts |
Posted - 2010-03-25 : 23:54:13
|
| TaraThanks 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 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
|
|
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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Schedule SSIS Package in Visual Studio