Showing posts with label shedule. Show all posts
Showing posts with label shedule. Show all posts

Sunday, February 19, 2012

Can I shedule packages from C#.net

I want to know what is the schedule of packages. and be able to change them from my .net Program.

ThanksYou can use the SSIS object model to execute packages directly, or you can schedule packages to run through SMO with the SMO.Agent namespace objects.
It's documented here: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/smo9mref/html/N_Microsoft_SqlServer_Management_Smo_Agent.htm
Thanks,
Kirk Haselden
Dev. Mngr
SSIS