private static int Main(string[] args) { var connectionString = ConfigurationManager.ConnectionStrings["MasterDb"]; var fileDestination = ConfigurationManager.AppSettings["FileDestination"]; var jobConfiguration = JobConfiguration.Create() .WithName("Ssis Up - Sample Data Load") .WithDescription("This is a sample data load") .WithSsisOwner("sa") .WithSsisServer(Environment.MachineName) .WithSchedule( ScheduleConfiguration.Create() .WithName("Saturday Load") .RunOn(FrequencyDay.Saturday) .StartingAt(new TimeSpan(10, 0, 0)) .ActivatedFrom(DateTime.Parse("1 Jan 2010")) .ActivatedUntil(DateTime.Parse("31 Dec 2020"))) .WithStep( StepConfiguration.Create() .WithId(1) .WithName("Load Movie Data") .WithSubSystem(SsisSubSystem.IntegrationServices) .WithDtsxFile(@".\Packages\SampleJob.dtsx") .WithDtsConfigurationFile(@".\Packages\SampleJob.dtsConfig") .WithDtsxFileDestination(fileDestination) .ExecuteCommand( string.Format( @"/FILE ""{0}\SampleJob.dtsx"" /CONFIGFILE ""{0}\SampleJob.dtsConfig"" /CHECKPOINTING OFF /REPORTING E /X86", fileDestination)) .OnSuccess(JobAction.QuitWithSuccess) .OnFailure(JobAction.QuitWithFailure)); var result = DeploymentConfiguration .Create() .ToDatabase(connectionString.ConnectionString) .WithJobConfiguration(jobConfiguration) .Deploy(); if (!result.Successful) { return(-1); } return(0); }
private static JobConfiguration CreateJobConfiguration() { var jobConfiguration = JobConfiguration.Create() .WithName("Test Name") .WithDescription("Test Description") .WithSsisOwner("Test SSIS Owner") .WithSsisServer("Test SSIS Server") .WithStep(StepConfiguration.Create() .WithName("Test Step Name") .WithId(1) .WithSubSystem(SsisSubSystem.TransactStructuredQueryLanguage) .ExecuteCommand("Test Command") .OnFailure(JobAction.QuitWithFailure) .OnSuccess(JobAction.QuitWithSuccess)) .WithSchedule(ScheduleConfiguration.Create() .WithName("Test Schedule Configuration") .RunOn(FrequencyDay.Monday) .ActivatedFrom(DateTime.Now) .ActivatedUntil(DateTime.Now.AddDays(1)) .StartingAt(TimeSpan.FromSeconds(6))); return jobConfiguration; }