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