void page_CreateNewConnection(object sender, EventArgs args) { IDtsConnectionService ConnectionService = (IDtsConnectionService)this.ServiceProvider.GetService(typeof(IDtsConnectionService)); if (ConnectionService == null) { Exception ex = new InvalidOperationException("Connection Service Unavailable"); this.ReportErrors(ex); return; } ArrayList connections = ConnectionService.CreateConnection("SSDS"); if (connections != null && connections.Count > 0) { ConnectionManager cm = connections[connections.Count - 1] as ConnectionManager; this.ComponentMetadata.RuntimeConnectionCollection[0].ConnectionManagerID = cm.ID; this.ComponentMetadata.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.ToConnectionManager90(cm); } return; }
public void Initialize(IDTSComponentMetaData100 dtsComponentMetadata, IServiceProvider serviceProvider) { this.serviceProvider = serviceProvider; this.metaData = dtsComponentMetadata; this.connectionService = (IDtsConnectionService)serviceProvider.GetService(typeof(IDtsConnectionService)); }
public void Initialize(TaskHost taskHost, IServiceProvider serviceProvider) { _taskHost = taskHost; IDtsConnectionService cs = serviceProvider.GetService(typeof(IDtsConnectionService)) as IDtsConnectionService; _connections = cs.GetConnections(); }
public void Initialize(Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSComponentMetaData100 dtsComponentMetadata, IServiceProvider serviceProvider) { this.serviceProvider = serviceProvider; this.metaData = dtsComponentMetadata; this.connectionService = (IDtsConnectionService)serviceProvider.GetService(typeof(IDtsConnectionService)); }
internal GeneralViewNode(TaskHost taskHost, IDtsConnectionService connectionService) { this.taskHost = taskHost; this.connectionService = connectionService; // Extract common values from the Task Host name = taskHost.Name; description = taskHost.Description; // Extract values from the task object WaitTaskMain task = taskHost.InnerObject as WaitTaskMain; if (task == null) { throw new ArgumentException("Type mismatch for taskHost inner object."); } AvailableConnections = LoadDBConnections(); WaitUntilTimeInternal = task.WaitUntilTimeInternal; SleepTimeInMinutes = task.SleepTimeInMinutes; DoNothingAndContinue = task.DoNothingAndContinue; SQLRepetitionFrequencyInMinutes = task.SQLRepetitionFrequencyInMinutes; SQLCheckStatement = task.SQLCheckStatement; SQLConnectionID = task.SQLConnectionID; var connection = GetConnectionById(task.SQLConnectionID); if (connection != null) { _sqlConnection = connection.Name; } MaximumSQLWaitTime = task.MaximumSQLWaitTime; }
public void Initialize(TaskHost taskHost, IServiceProvider serviceProvider) { this.taskHost = taskHost; this.serviceProvider = serviceProvider; IDtsConnectionService connectionService = serviceProvider.GetService(typeof(IDtsConnectionService)) as IDtsConnectionService; this.connections = connectionService.GetConnections(); }
public HDFSTaskUIForm(Microsoft.SqlServer.Dts.Runtime.TaskHost taskHost, Microsoft.SqlServer.Dts.Runtime.Connections connections, IServiceProvider serviceProvider) : this() { this.taskHost = taskHost; this.connections = connections; this.serviceProvider = serviceProvider; this.connectionService = serviceProvider.GetService(typeof(IDtsConnectionService)) as IDtsConnectionService; }
public RabbitMQSourceUIForm(Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSComponentMetaData100 metaData, IServiceProvider serviceProvider) : this() { this.metaData = metaData; this.serviceProvider = serviceProvider; this.connectionService = (IDtsConnectionService)serviceProvider.GetService(typeof(IDtsConnectionService)); this.designTimeInstance = metaData.Instantiate(); }
public CRMDestinationAdapterUIForm(Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSComponentMetaData100 metaData, IDtsConnectionService connectionService) : this() { this.metaData = metaData; this.connectionService = connectionService; this.designTimeInstance = metaData.Instantiate(); }
public HDFSDestinationFormUI(IDTSComponentMetaData100 metaData, IServiceProvider serviceProvider) : this() { this.metaData = metaData; this.serviceProvider = serviceProvider; this.connectionService = (IDtsConnectionService)serviceProvider.GetService(typeof(IDtsConnectionService)); this.designTimeInstance = metaData.Instantiate(); }
public MappingsUIForm(Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSComponentMetaData100 metaData, IDtsConnectionService connectionService, int Operation, Item EntityItem, Mapping Mapping) : this() { this.metaData = metaData; this.connectionService = connectionService; this.operation = Operation; this.entityItem = EntityItem; this.mapping = Mapping; }
public void Initialize(TaskHost taskHost, IServiceProvider serviceProvider) { //throw new NotImplementedException(); //System.Windows.Forms.MessageBox.Show("Initialize"); this.taskHost = taskHost; IDtsConnectionService cs = serviceProvider.GetService(typeof(IDtsConnectionService)) as IDtsConnectionService; this.connections = cs.GetConnections(); return; }
public SSHFTPTaskUIForm(TaskHost taskHostValue, IServiceProvider serviceProvider) { _taskHostValue = taskHostValue; _serviceProvider = serviceProvider; InitializeComponent(); if (_taskHostValue.Properties["SSHConnMgrName"].GetValue(_taskHostValue) != null) { _SSHconnMgrName = _taskHostValue.Properties["SSHConnMgrName"].GetValue(_taskHostValue).ToString(); } if (_taskHostValue.Properties["SendFilesSourceConnectionManagerName"].GetValue(_taskHostValue) != null) { _sendFilesSourceConnectionManagerName = _taskHostValue.Properties["SendFilesSourceConnectionManagerName"].GetValue(_taskHostValue).ToString(); } if (_taskHostValue.Properties["SendFilesDestinationDirectory"].GetValue(_taskHostValue) != null) { SendFilesDestinationdirectorytextBox.Text = _taskHostValue.Properties["SendFilesDestinationDirectory"].GetValue(_taskHostValue).ToString(); } if (_taskHostValue.Properties["ReceiveFilesDestinationConnectionManagerName"].GetValue(_taskHostValue) != null) { _receiveFilesDestinationConnectionManagerName = _taskHostValue.Properties["ReceiveFilesDestinationConnectionManagerName"].GetValue(_taskHostValue).ToString(); } if (_taskHostValue.Properties["ReceiveFilesSourceFile"].GetValue(_taskHostValue) != null) { ReceiveFilesSourceFiletextBox.Text = _taskHostValue.Properties["ReceiveFilesSourceFile"].GetValue(_taskHostValue).ToString(); } if (_taskHostValue.Properties["Operation"].GetValue(_taskHostValue) != null) { if ((SSHFTPOperation)_taskHostValue.Properties["Operation"].GetValue(_taskHostValue) == SSHFTPOperation.SendFiles) { OperationTypecomboBox.SelectedIndex = 0; } if ((SSHFTPOperation)_taskHostValue.Properties["Operation"].GetValue(_taskHostValue) == SSHFTPOperation.ReceiveFiles) { OperationTypecomboBox.SelectedIndex = 1; } } setPanels(OperationTypecomboBox); IDtsConnectionService dtsConnectionService = (IDtsConnectionService)serviceProvider.GetService(typeof(IDtsConnectionService)); _dtsConnectionService = dtsConnectionService; //OperationTypecomboBox.SelectedIndex = 0; PopulateConnectionsCombo(SSHConnectioncomboBox, "SSH", _SSHconnMgrName, null); PopulateConnectionsCombo(SendFilesSourceConnectioncomboBox, "FILE", _sendFilesSourceConnectionManagerName, DTSFileConnectionUsageType.FileExists); PopulateConnectionsCombo(DestinationConnectioncomboBox, "FILE", _receiveFilesDestinationConnectionManagerName, DTSFileConnectionUsageType.FolderExists); }
internal GeneralViewNode(TaskHost taskHost, IDtsConnectionService connectionService) { // Extract common values from the Task Host name = taskHost.Name; description = taskHost.Description; // Extract values from the task object HelloWorldTask task = taskHost.InnerObject as HelloWorldTask; if (task == null) { string msg = string.Format(CultureInfo.CurrentCulture, "Type mismatch for taskHost inner object. Received: {0} Expected: {1}", taskHost.InnerObject.GetType().Name, typeof(HelloWorldTask).Name); throw new ArgumentException(msg); } displayText = task.DisplayText; }
/// <summary> /// Creates a new connectiionManager /// </summary> /// <param name="sender">event sender</param> /// <param name="e">event arguments</param> private void btnNewConMgr_Click(object sender, EventArgs e) { IDtsConnectionService connectionService = (IDtsConnectionService)ServiceProvider.GetService(typeof(IDtsConnectionService)); ArrayList newConnections = connectionService.CreateConnection("ADO.NET"); foreach (ConnectionManager connMgr in newConnections) { if (connMgr.CreationName.StartsWith("ADO.NET")) { _connectionManagerList.Add(connMgr); cmbConMgr.SelectedItem = connMgr; } } }
private void IsagConnectionManager_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e) { IDtsConnectionService connectionService = (IDtsConnectionService)ServiceProvider.GetService(typeof(IDtsConnectionService)); ArrayList newConnections = connectionService.CreateConnection("ADO.NET"); foreach (ConnectionManager connMgr in newConnections) { if (connMgr.CreationName.StartsWith("ADO.NET")) { _connectionManagerList.Add(connMgr); this.DataBind(); this.Text = connMgr.Name; } } }
public ReverseStringUIForm(IDTSComponentMetaData100 dtsComponentMetaData, IServiceProvider serviceProvider, Connections connections) { InitializeComponent(); // Store constructor parameters for later _dtsComponentMetaData = dtsComponentMetaData; // Get design-time interface for changes and validation _designTimeComponent = _dtsComponentMetaData.Instantiate(); // Get Input _input = _dtsComponentMetaData.InputCollection[0]; // Set any form controls that host component properties here // None required for ReverseString component // Populate DataGridView with columns SetInputVirtualInputColumns(); _connections = connections; // Get IDtsConnectionService and store. IDtsConnectionService dtsConnectionService = serviceProvider.GetService(typeof(IDtsConnectionService)) as IDtsConnectionService; _dtsConnectionService = dtsConnectionService; // Get Connections collection, and get name of currently selected connection. string connectionName = ""; if (_dtsComponentMetaData.RuntimeConnectionCollection[0] != null) { IDTSRuntimeConnection100 runtimeConnection = _dtsComponentMetaData.RuntimeConnectionCollection[0]; if (runtimeConnection != null && runtimeConnection.ConnectionManagerID.Length > 0 && _connections.Contains(runtimeConnection.ConnectionManagerID)) { connectionName = _connections[runtimeConnection.ConnectionManagerID].Name; } } // Populate connections combo. PopulateConnectionsCombo(this.cmbSqlConnections, Connection_Type, connectionName); }
private void connectionComboBox_SelectedIndexChanged(object sender, EventArgs e) { // Special case: the <New...> item on the combo box causes us to try to create a new connection manager. if ((string)connectionComboBox.SelectedItem == "New connection") { // Fetch the IDtsConnectionService. It provides facilities to present the user with // a new connection dialog, so they don't need to exit the (modal) UI to create one. IDtsConnectionService connService = (IDtsConnectionService)serviceProvider_.GetService(typeof(IDtsConnectionService)); System.Collections.ArrayList created = connService.CreateConnection("ADO.NET:SQL"); // CreateConnection() returns back a list of connections that were created -- go ahead // and update our list with those new items. foreach (ConnectionManager cm in created) { connectionComboBox.Items.Insert(0, cm.Name); } // If we created an item, we select it in the combo box, otherwise, clear the selection entirely. if (created.Count > 0) { connectionComboBox.SelectedIndex = 0; } else { connectionComboBox.SelectedIndex = -1; } } // No matter what, we set the current connection manager to the chosen item if it's real. if (connections_.Contains(connectionComboBox.SelectedItem)) { this.component_.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.ToConnectionManager90(connections_[connectionComboBox.SelectedItem]); this.component_.RuntimeConnectionCollection[0].ConnectionManagerID = connections_[connectionComboBox.SelectedItem].ID; } needsNewMetaData_ = true; }
public GeneralViewNode(TaskHost host, IDtsConnectionService connectionService) { ConnectionService = connectionService; //General properties m_name = host.Name; m_description = host.Description; //Connection properties GenerateSsrsTask task; if (host.TryGetTask(out task)) { HttpConnection = task.ServerConnection; m_format = task.ReportFormat; m_path = task.ReportPath; } ; }
public SSHExecuteCommandTaskUIForm(TaskHost taskHostValue, IServiceProvider serviceProvider) { _taskHostValue = taskHostValue; _serviceProvider = serviceProvider; InitializeComponent(); if (_taskHostValue.Properties["CommandText"].GetValue(_taskHostValue) != null) { _commandText = _taskHostValue.Properties["CommandText"].GetValue(_taskHostValue).ToString(); } //ConnMgrName if (_taskHostValue.Properties["ConnMgrName"].GetValue(_taskHostValue) != null) { _connMgrName = _taskHostValue.Properties["ConnMgrName"].GetValue(_taskHostValue).ToString(); } IDtsConnectionService dtsConnectionService = (IDtsConnectionService)serviceProvider.GetService(typeof(IDtsConnectionService)); _dtsConnectionService = dtsConnectionService; PopulateConnectionsCombo(ConnectionManagercomboBox, "SSH", _connMgrName); }
/// <summary>Called to initialize the <see cref="Node"/> property.</summary> /// <param name="host">The host.</param> /// <param name="connectionService">The connection service.</param> /// <returns>The object to set as the <see cref="Node"/> of the view.</returns> protected internal abstract T CreateNode(TaskHost host, IDtsConnectionService connectionService);
public void Initialize(TaskHost taskHost, IServiceProvider serviceProvider) { this._taskHost = taskHost; this._connectionService = serviceProvider.GetService(typeof(IDtsConnectionService)) as IDtsConnectionService; }
protected override ParameterViewNode CreateNode(TaskHost host, IDtsConnectionService connectionService) { return(new ParameterViewNode()); }
protected override GeneralViewNode CreateNode(TaskHost host, IDtsConnectionService connectionService) { return(new GeneralViewNode(host, connectionService)); }
internal GeneralViewNode(TaskHost taskHost, IDtsConnectionService connectionService) { this.iDtsConnection = connectionService; this.myTaskHost = taskHost; this._variableService = this.myTaskHost.Site.GetService(typeof (IDtsVariableService)) as IDtsVariableService; // Extract common values from the Task Host name = taskHost.Name; description = taskHost.Description; // Extract values from the task object ExecuteAzureMLBatch task = taskHost.InnerObject as ExecuteAzureMLBatch; if (task == null) { string msg = string.Format(CultureInfo.CurrentCulture, "Type mismatch for taskHost inner object. Received: {0} Expected: {1}", taskHost.InnerObject.GetType().Name, typeof(ExecuteAzureMLBatch).Name); throw new ArgumentException(msg); } connection = task.Connection; azureMLUrl = task.AzureMLBaseURL; azureMLKey = task.AzureMLAPIKey; blobName = task.BlobName; sourceType = task.InputSource; destinationType = task.OutputDestination; switch (sourceType) { case (SourceType.BlobPath): sourceBlobPath = task.Source; break; case (SourceType.DirectInput): sourceDirect = task.Source; break; case (SourceType.FileConnection): source = task.Source; break; case (SourceType.Variable): sourceVariable = task.Source; break; default: break; } switch (destinationType) { case (DestinationType.FileConnection): destination = task.Destination; break; case (DestinationType.Variable): destinationVariable = task.Destination; break; default: break; } }
protected override OutputViewNode CreateNode(TaskHost host, IDtsConnectionService connectionService) { return(new OutputViewNode(host)); }