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 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;
if (!packageName.ToLower().EndsWith(".dtsx"))
packageName += ".dtsx";
var events = new PackageEvents();
var package = app.LoadFromSqlServer(packageName, server, etl.UserName, etl.Password, 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);
}