protected override Package Load(IEtl etl, Application app) { var packageName = etl.Path + etl.Name; if (!packageName.ToLower().EndsWith(".dtsx")) packageName += ".dtsx"; var events = new PackageEvents(); var package = app.LoadPackage(packageName, events); return package; }
protected override Package Load(IEtl etl, Application app) { var server = etl.Server.Replace(" ", ""); if(server.ToLower()=="(local)") server="."; var packageName = etl.Path + etl.Name; var events = new PackageEvents(); var package = app.LoadFromDtsServer(packageName, server, events); return package; }
protected override Package Load(IEtl etl, Application app) { var server = etl.Server.Replace(" ", ""); if(server.ToLower()=="(local)") server="."; var packageName = etl.Path + etl.Name; if (!packageName.ToLower().EndsWith(".dtsx")) packageName += ".dtsx"; var events = new PackageEvents(); var package = app.LoadFromSqlServer(packageName, server, etl.UserName, etl.Password, events); return package; }
public override IExecutionResult Run() { var app = new Application(); if (!string.IsNullOrEmpty(Etl.Password)) app.PackagePassword = Etl.Password; var package = Load(Etl, app); Parameterize(Etl.Parameters, ref package); var events = new PackageEvents(); var pkgResults = package.Execute(null, null, events, null, null); var result = (ExecResult)pkgResults; return EtlRunResult.Build(result, events); }
protected override Package Load(IEtl etl, Application app) { var packageName = etl.Path + etl.Name; if (!packageName.ToLower().EndsWith(".dtsx")) { packageName += ".dtsx"; } var events = new PackageEvents(); var package = app.LoadPackage(packageName, events); return(package); }
protected override Package Load(IEtl etl, Application app) { var server = etl.Server.Replace(" ", ""); if (server.ToLower() == "(local)") { server = "."; } var packageName = etl.Path + etl.Name; var events = new PackageEvents(); var package = app.LoadFromDtsServer(packageName, server, events); return(package); }
public override IExecutionResult Run() { var app = new Application(); if (!string.IsNullOrEmpty(Etl.Password)) { app.PackagePassword = Etl.Password; } var package = Load(Etl, app); Parameterize(Etl.Parameters, ref package); var events = new PackageEvents(); var pkgResults = package.Execute(null, null, events, null, null); var result = (ExecResult)pkgResults; return(EtlRunResult.Build(result, events)); }
protected override Package Load(IEtl etl, Application app) { var server = etl.Server.Replace(" ", ""); if (server.ToLower() == "(local)") { server = "."; } var packageName = etl.Path + etl.Name; if (!packageName.ToLower().EndsWith(".dtsx")) { packageName += ".dtsx"; } var events = new PackageEvents(); var package = app.LoadFromSqlServer(packageName, server, etl.UserName, etl.Password, events); return(package); }