public void Execute_ExistingSamplePackageWithParameter_SuccessAndParameterUsed()
{
var destPath = DiskOnFile.GetDirectoryPath() + "SampleFile.txt";
if(File.Exists(destPath))
File.Delete(destPath);
var etl = new EtlXml();
etl.Path = @"Etl\";
etl.Name = "Sample.dtsx";
etl.Password = "******";
var param = new EtlParameterXml();
param.Name="DestinationPath";
param.StringValue = destPath;
etl.InternalParameters.Add(param);
var runner = new EtlFileRunner(etl);
var result = runner.Run();
Assert.That(result.IsSuccess, Is.True);
Assert.That(File.Exists(destPath), Is.True);
}
public void Execute_ExistingSamplePackageWithParameterWithInvalidValue_FailureWithMessage()
{
var destPath = DiskOnFile.GetDirectoryPath() + @"\/.txt";
if (File.Exists(destPath))
File.Delete(destPath);
var etl = new EtlXml();
etl.Path = @"Etl\";
etl.Name = "Sample.dtsx";
etl.Password = "******";
var param = new EtlParameterXml();
param.Name = "DestinationPath";
param.StringValue = destPath;
etl.InternalParameters.Add(param);
var runner = new EtlFileRunner(etl);
var result = runner.Run();
Assert.That(result.IsSuccess, Is.False);
Assert.That(result.Message, Is.StringContaining("invalid characters"));
}
public void Execute_ExistingSamplePackageWithVariable_SuccessAndParameterUsed()
{
var limitValue = 5;
var destPath = DiskOnFile.GetDirectoryPath() + "VariableFile.txt";
if (File.Exists(destPath))
File.Delete(destPath);
var etl = new EtlXml();
etl.Path = @"Etl\";
etl.Name = "Sample.dtsx";
etl.Password = "******";
var param = new EtlParameterXml();
param.Name = "DestinationPath";
param.StringValue = destPath;
etl.InternalParameters.Add(param);
var variable = new EtlParameterXml();
variable.Name = "User::Limit";
variable.StringValue = String.Format("top {0} *", limitValue);
etl.InternalParameters.Add(variable);
var runner = new EtlFileRunner(etl);
var result = runner.Run();
Assert.That(result.IsSuccess, Is.True);
Assert.That(File.Exists(destPath), Is.True);
var content = File.ReadAllLines(destPath);
Assert.That(content.Count(), Is.EqualTo(limitValue+1));
}