public ISScriptComponentConnection(ISScriptComponent parentComponent, ISConnectionManager referenceConnection, string connectionNameInComponent) { _connection = parentComponent.AddConnection_m(referenceConnection.Name, connectionNameInComponent); if (parentComponent.SourceCode.Length > 0) { parentComponent.RebuildProject(null); } }
public void AssignConnectionManager(ISConnectionManager cm) { AssignConnectionManager(cm.ConnectionManager); if (!(String.IsNullOrEmpty(TableOrViewName))) { RetrieveMetaData(Connection, DestinationPassword); } }
public bool RetrieveMetaData(ISConnectionManager connMgr, string password) { string origConn = ComponentMetaData.RuntimeConnectionCollection[0].Name; ConnectionManager cm = ParentDataFlowTask.RootPackage.Connections.Add(connMgr.CreationName) as ConnectionManager; cm.Name = "DummyConnToForce"; cm.ConnectionString = connMgr.ConnectionString; cm.Properties["Password"].SetValue(cm, password); SetUpConnection(cm); bool success = RetrieveMetaData(); SetUpConnection(GetConnectionManager(origConn)); ParentDataFlowTask.RootPackage.Connections.Remove("DummyConnToForce"); return(success); }
public ISAdoNetSourceComponent(ISDataFlowTask parentDataFlowTask, string componentname, ISConnectionManager cm, bool connectionIsOffline = false) : this(parentDataFlowTask, componentname) { if (!(connectionIsOffline)) { if (cm != null) { AssignConnectionManager(cm); } else { System.Console.WriteLine("WARN::: No Connection Manager is attached. Please use the AssignConnectionManager method to assign a Connection Manager."); } } }
public void AssignConnectionManager(ISConnectionManager cm) { AssignConnectionManager(cm.ConnectionManager); }
/// <summary> /// Add a connection to the script component /// </summary> /// <param name="referenceConnection"></param> /// <param name="connectionNameInComponent"></param> public void AddConnection(ISConnectionManager referenceConnection, string connectionNameInComponent) { AddConnection_m(referenceConnection.Name, connectionNameInComponent); }
public void AssignConnectionManager(ISConnectionManager cm) { AssignConnectionManager(cm.ConnectionManager); RetrieveMetaData(); }