/// <summary>
/// Metodo para lanzar las ETL
/// </summary>
/// <param name="pkgLocation"></param>
public void lanzarETL(string pkgLocation, ConfigGlassWindow parent)
{
Package pkg;
Microsoft.SqlServer.Dts.Runtime.Application app;
DTSExecResult pkgResults;
parentWin = parent;
eventListener = new MyEventListener(parentWin);
//pkgLocation =
// @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services" +
// @"\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx";
app = new Microsoft.SqlServer.Dts.Runtime.Application();
pkg = app.LoadPackage(pkgLocation, eventListener);
//pkg.Variables.Add("strNombreServidorLocal", false, "", "ASINE1159\\SQLEXPRESS");
//pkg.Variables["strNombreServidorLocal"].Value = "ASINE1159\\SQLEXPRESS";
pkgResults = pkg.Execute(null, pkg.Variables, eventListener, null, null);
//errores.Add(pkgResults.ToString());
//Console.WriteLine(pkgResults.ToString());
//Console.ReadKey();
}
/// <summary>
///
/// </summary>
public MyEventListener(ConfigGlassWindow parent)
{
parentWin = parent;
errores = new List<string>();
}