public void GeneratePackage()
{
try
{
var importSchema = _repository.LoadOne();
Console.WriteLine("import schema elements:");
foreach (var importSchemaElement in importSchema.Elements)
{
Console.WriteLine(importSchemaElement.Name);
}
var ssisImportScripterFactory = new SsisImportScripterFactory();
var ssisImportScripter = ssisImportScripterFactory.GetSsisImportScripter
(
_importName,
_importSchemaName,
_generatedScriptPath,
_sourceConnectionString,
_destinationConnectionString,
_stagingDatabaseConnectionString,
_defaultImportRunId,
_defaultSourceIds,
_logFileDir,
importSchema
);
ssisImportScripter.Generate();
}
catch (Exception err)
{
Console.WriteLine("Exception caught during SSIS package generation.");
Console.WriteLine(err.ToString());
Console.WriteLine(ToString());
}
Console.WriteLine("Generated package " + _generatedScriptPath);
}
