/// <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)); }