public void CheckIfDTExecUtilityIsHavingValidArguments()
{
string filePath = @"C:\PROGRA~2\MICROS~2\130\DTS\Binn\DTExec.exe";
DTExecUtility utility = new DTExecUtility(filePath)
{
DtsxPackagePath = @"E:\Practice\SSIS\PackageSamples\FileTransform.dtsx"
};
utility.UserVariables.Add("inputFilePath", @"E:\Practice\SSIS\IntegrationPackages\CensusIntegration\Working\cbp02us.txt");
utility.UserVariables.Add("everythingFilePath", @"E:\Practice\SSIS\IntegrationPackages\DataTransform\Output\EverythingCLI.csv");
utility.UserVariables.Add("thresholdFilePath", @"E:\Practice\SSIS\IntegrationPackages\DataTransform\Output\ThresholdCLI.csv");
utility.UserVariables.Add("zeroFilePath", @"E:\Practice\SSIS\IntegrationPackages\DataTransform\Output\ZeroCLI.csv");
Assert.IsTrue(!string.IsNullOrEmpty(utility.Arguments));
}
private void ExecutePackage(IFileValidator fileValidator)
{
DTExecUtility utility = new DTExecUtility(FilePath)
{
DtsxPackagePath = DtsxPackagePath,
UserVariables = fileValidator.UserVariables
};
string result = string.Empty;
int returnCode = utility.TryExecute(out result);
if (returnCode == 0)
{
logger.Info(result);
}
else
{
logger.Warn(result);
}
}
