/// <summary>
/// Called to invoke the UI.
/// </summary>
/// <param name="parentWindow">The calling window</param>
/// <param name="variables">The SSIS variables</param>
/// <param name="connections">The SSIS connections</param>
/// <returns>True all works</returns>
bool IDtsComponentUI.Edit(IWin32Window parentWindow, Microsoft.SqlServer.Dts.Runtime.Variables variables, Microsoft.SqlServer.Dts.Runtime.Connections connections)
{
this.ClearErrors();
try
{
Debug.Assert(this.componentMetadata != null, "Original Component Metadata is not OK.");
this.designtimeComponent = this.componentMetadata.Instantiate();
Debug.Assert(this.designtimeComponent != null, "Design-time component object is not OK.");
// Cache the virtual input so the available columns are easily accessible.
this.LoadVirtualInput();
// Cache variables and connections.
this.variables = variables;
this.connections = connections;
// Here comes the UI that will be invoked in EditImpl virtual method.
return(this.EditImpl(parentWindow));
}
catch (Exception ex)
{
this.ReportErrors(ex);
return(false);
}
}
public bool ejecutar()
{
try
{
//Creamos una aplicación para realizar la ejecución
Microsoft.SqlServer.Dts.Runtime.Application app = new Microsoft.SqlServer.Dts.Runtime.Application();
//Creamos un paquete y le asignamos el que queremos ejecutar
//Package package = app.LoadPackage(@"C:\Package_Usuario.dtsx", null);
Package package = app.LoadPackage(this.urlPackage, null);
//package.Variables
Microsoft.SqlServer.Dts.Runtime.Variables variables = package.Variables;
variables["proceso"].Value = this.pro.idproceso;
//Ejecutamos el paquete
DTSExecResult resultEtl = package.Execute(null, variables, null, null, null);
//Imprimimos el resultado de la ejecución
//Console.WriteLine("Resultado de la ejecución: {0}", result.ToString());
if (resultEtl != Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex) {
return(false);
}
}
public HTTPParametersGui(Microsoft.SqlServer.Dts.Runtime.Variables vars, string[] inputHttpCols = null)
{
_vars = vars;
InitializeComponent();
bindingType.DataSource = Enum.GetNames(typeof(ParamBinding));
dataGridView1.CellBeginEdit += dataGridView1_CellBeginEdit;
dataGridView1.CellValueChanged += dataGridView1_CellValueChanged;
dataGridView1.RowValidating += dataGridView1_RowValidating;
_input_options = inputHttpCols; // May be null and it's ok.
_model = new List <HTTPParameter>();
}
bool IDtsComponentUI.Edit(System.Windows.Forms.IWin32Window parentWindow, Microsoft.SqlServer.Dts.Runtime.Variables variables, Microsoft.SqlServer.Dts.Runtime.Connections connections)
{
this.ClearErrors();
try
{
Debug.Assert(this.componentMetadata != null, "Original Component Metadata is not OK.");
this.designtimeComponent = this.componentMetadata.Instantiate();
Debug.Assert(this.designtimeComponent != null, "Design-time component object is not OK.");
//Cache the virtual input
this.LoadVirtualInput();
//cache variables and connections
this.variables = variables;
this.connections = connections;
return(EditImpl(parentWindow));
}
catch (Exception ex)
{
this.ReportErrors(ex);
return(false);
}
}
public bool Edit(IWin32Window parentWindow, DTSRuntime.Variables variables, DTSRuntime.Connections connections)
{
ShowForm(parentWindow);
return(true);
}
private void SetParameterMapping(IList <DataFlowSourceQueryParameter> parameters, DTS.Variables variables)
{
StringBuilder parameterBuilder = new StringBuilder();
foreach (DataFlowSourceQueryParameter param in parameters)
{
if (variables.Contains(param.VariableName))
{
DTS.Variable variable = variables[param.VariableName];
parameterBuilder.AppendFormat("\"{0}\",{1};", param.Name, variable.ID);
}
else
{
MessageEngine.Global.Trace(Severity.Error, Resources.DTSVariableNotExists, param.VariableName);
}
}
_instance.SetComponentProperty("ParameterMapping", parameterBuilder.ToString());
}
/// <summary>
/// Called to invoke the UI.
/// </summary>
/// <param name="parentWindow">The calling window</param>
/// <param name="variables">The SSIS variables</param>
/// <param name="connections">The SSIS connections</param>
/// <returns>True all works</returns>
bool IDtsComponentUI.Edit(IWin32Window parentWindow, Microsoft.SqlServer.Dts.Runtime.Variables variables, Microsoft.SqlServer.Dts.Runtime.Connections connections)
{
return(Edit(parentWindow, variables, connections));
}
