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 |
|
Gopher
Yak Posting Veteran
83 Posts |
 Posted - 2008-01-15 : 04:36:35
|
| Hi AllI have created a SSIS Package to complete various tasks and I have managed to deploy it on SQL, however I can't find it in the Management Studio. I just want to be able to schedule this package to run as a job.Any Ideas? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-15 : 05:08:47
|
| To see the SSIS package in sql server mgmt studio,connect to Integration services engine on server where you have deployed and then open Stored Packages and then look into FileSystem if you had given option to store on file system or MSDB if you had opted to store on SQL Server.To schedule running create a scheduled SQL Agent job for running the SSIS package on server.This article should help on this:-http://technet.microsoft.com/en-us/library/ms139805.aspxhttp://www.microsoft.com/technet/prodtechnol/sql/2005/mgngssis.mspx |
 |
|
|
Gopher
Yak Posting Veteran
83 Posts |
Posted - 2008-01-15 : 07:49:56
|
| FantasticThanks that worked perfectly! |
|
|
|
|
|
|
Scheduling SSIS Package