protected Pattern(Vulcan.Packages.VulcanPackage vulcanPackage,DTS.IDTSSequence parentContainer)
{
_vulcanPackage = vulcanPackage;
_parentContainer = parentContainer;
_firstExecutableGeneratedByPattern = null;
_lastExecutableGeneratedByPattern = null;
}
public FileSystemTask(
Packages.VulcanPackage vulcanPackage,
string name,
string taskDescription,
DTS.IDTSSequence parentContainer,
string sourceConnection,
string destConnection,
Microsoft.SqlServer.Dts.Tasks.FileSystemTask.DTSFileSystemOperation operation
)
:
base(
vulcanPackage,
name,
taskDescription,
parentContainer
)
{
Connection source = new Connection(vulcanPackage, sourceConnection, sourceConnection, "FILE", String.Format("\"{0}\"", ExpressionPathBuilder.EscapeBackslashes(sourceConnection)));
Connection dest = new Connection(vulcanPackage, destConnection, destConnection, "FILE", String.Format("\"{0}\"", ExpressionPathBuilder.EscapeBackslashes(destConnection)));
source.SetProperty("FileUsageType", 2);
dest.SetProperty("FileUsageType", 2);
fileSystemTask = (DTS.TaskHost)parentContainer.Executables.Add("STOCK:FileSystemTask");
fileSystemTask.Name = name;
this.Task.Operation = operation;
this.Task.Source = source.ConnectionManager.ID;
this.Task.Destination = dest.ConnectionManager.ID;
}
protected Task(Packages.VulcanPackage vulcanPackage, string taskName, string taskDescription, DTS.IDTSSequence parentContainer)
{
_vulcanPackage = vulcanPackage;
_name = taskName;
_description = taskDescription;
_parentContainer = parentContainer;
}
protected Task(Packages.VulcanPackage vulcanPackage ,string taskName, string taskDescription, DTS.IDTSSequence parentContainer)
{
_vulcanPackage = vulcanPackage;
_name = taskName;
_description = taskDescription;
_parentContainer = parentContainer;
}
protected Pattern(Vulcan.Packages.VulcanPackage vulcanPackage, DTS.IDTSSequence parentContainer)
{
_vulcanPackage = vulcanPackage;
_parentContainer = parentContainer;
_firstExecutableGeneratedByPattern = null;
_lastExecutableGeneratedByPattern = null;
}
public ETLPattern(Packages.VulcanPackage vulcanPackage, DTS.IDTSSequence parentContainer)
:
base(
vulcanPackage,
parentContainer
)
{
}
public LogtainerPattern(Vulcan.Packages.VulcanPackage vulcanPackage, DTS.IDTSSequence parentContainer)
:
base(
vulcanPackage,
parentContainer
)
{
}
public void SetBaseProperties(SSIS.IDTSSequence sequence, SSIS.EventsProvider eventsProvider)
{
this.Executables = sequence.Executables;
this.PrecedenceConstraints = sequence.PrecedenceConstraints;
if (eventsProvider != null)
{
this.EventHandlers = eventsProvider.EventHandlers;
}
}
public SsisSequence(DTS.IDTSSequence dtsSequence, SequenceTask objContainer)
{
if (objContainer.ConstraintMode != "Linear" && objContainer.ConstraintMode != "Parallel")
{
MessageEngine.Global.Trace(Severity.Error, "Unknown ConstraintMode: {0} ", objContainer.ConstraintMode);
}
_constraintMode = objContainer.ConstraintMode;
_transactionMode = objContainer.TransactionMode;
_dtsSequence = dtsSequence;
}
public SsisSequence(DTS.IDTSSequence dtsSequence, SequenceTask objContainer)
{
if (objContainer.ConstraintMode != "Linear" && objContainer.ConstraintMode != "Parallel")
{
MessageEngine.Global.Trace(Severity.Error, "Unknown ConstraintMode: {0} ", objContainer.ConstraintMode);
}
_constraintMode = objContainer.ConstraintMode;
_transactionMode = objContainer.TransactionMode;
_dtsSequence = dtsSequence;
}
internal SSISEmitterContext(SsisPackage package, SsisSequence parentSequence, PluginLoader<ISSISEmitter, PhysicalIRMappingAttribute> pluginLoader)
{
_package = package;
_ssisSequence = parentSequence;
_guid = Guid.NewGuid();
_message = MessageEngine.Create(String.Format(System.Globalization.CultureInfo.InvariantCulture, "SSISFactory: {0}", _guid.ToString()));
if (_ssisSequence != null)
{
_parentContainer = _ssisSequence.DTSSequence;
}
_pluginLoader = pluginLoader;
}
internal SSISEmitterContext(SsisPackage package, SsisSequence parentSequence, PluginLoader <ISSISEmitter, PhysicalIRMappingAttribute> pluginLoader)
{
_package = package;
_ssisSequence = parentSequence;
_guid = Guid.NewGuid();
_message = MessageEngine.Create(String.Format(System.Globalization.CultureInfo.InvariantCulture, "SSISFactory: {0}", _guid.ToString()));
if (_ssisSequence != null)
{
_parentContainer = _ssisSequence.DTSSequence;
}
_pluginLoader = pluginLoader;
}
public void AddPrecedenceConstraint(DTS.Executable from, DTS.Executable to, DTS.IDTSSequence parentContainer)
{
if (from != null && to != null && parentContainer != null)
{
if (
parentContainer.Executables.Contains(this.ExtractNameFromDTSExecutable(from)) &&
parentContainer.Executables.Contains(this.ExtractNameFromDTSExecutable(to))
)
{
DTS.PrecedenceConstraint pc =
parentContainer.PrecedenceConstraints.Add(from, to);
pc.Name = ExtractNameFromDTSExecutable(from) + "_" + ExtractNameFromDTSExecutable(to);
}
}
}
public DTS.Sequence AddSequenceContainer(string name, DTS.IDTSSequence parentContainer)
{
if (name != null && parentContainer != null)
{
if (parentContainer.Executables.Contains(name))
{
if (parentContainer.Executables[name] is DTS.IDTSSequence)
{
return((DTS.Sequence)parentContainer.Executables[name]);
}
}
DTS.Sequence sequence = (DTS.Sequence)parentContainer.Executables.Add("STOCK:Sequence");
sequence.Name = name;
return(sequence);
}
return(null);
}
public ExecutePackageTask(
Packages.VulcanPackage vulcanPackage,
string name,
string taskDescription,
DTS.IDTSSequence parentContainer,
Connection packageConnection
)
:
base(
vulcanPackage,
name,
taskDescription,
parentContainer
)
{
executePackageTaskHost = (DTS.TaskHost)parentContainer.Executables.Add("STOCK:ExecutePackageTask");
executePackageTaskHost.Name = name;
Task.Connection = packageConnection.ConnectionManager.ID;
}
public SQLTask(Packages.VulcanPackage package, string name, string description, DTS.IDTSSequence parentContainer, Connection destinationConnection, Dictionary <string, object> propertiesDictionary)
:
base(
package,
name,
description,
parentContainer
)
{
this._expressionBuilder = new Vulcan.Common.Helpers.ExpressionPathBuilder(package);
_sqlTask = (DTS.TaskHost)parentContainer.Executables.Add("STOCK:SQLTask");
_sqlTask.Name = name;
_sqlTask.Description = description;
SetProperties(propertiesDictionary);
if (destinationConnection != null)
{
SetProperty("Connection", destinationConnection.ConnectionManager.Name);
}
}
public SQLTask(Packages.VulcanPackage package, string name, string description, DTS.IDTSSequence parentContainer, Connection destinationConnection)
:
this(
package,
name,
description,
parentContainer,
destinationConnection,
null
)
{
}
public static Pattern ProcessPattern(Packages.VulcanPackage vulcanPackage, DTS.IDTSSequence parentContainer, XPathNavigator patternNavigator, Pattern previousPattern)
{
DTS.Executable lastExecutableInPattern = null;
if (previousPattern != null)
{
lastExecutableInPattern = previousPattern.FirstExecutableGeneratedByPattern;
}
Pattern p = null;
Message.Trace(Severity.Debug, "Emitting Pattern {0}", patternNavigator.Name);
try
{
switch (patternNavigator.Name)
{
case "HelperTables":
p = new HelperTablePattern(vulcanPackage, parentContainer);
p.Emit(patternNavigator);
break;
case "ETL":
p = new ETLPattern(vulcanPackage, parentContainer);
p.Emit(patternNavigator);
break;
case "StoredProc":
p = new StoredProcPattern(vulcanPackage, parentContainer);
p.Emit(patternNavigator);
break;
case "Dimensions":
p = new DimensionsPattern(vulcanPackage, parentContainer);
p.Emit(patternNavigator);
break;
case "Logtainer":
p = new LogtainerPattern(vulcanPackage, parentContainer);
p.Emit(patternNavigator);
break;
case "LogUpdate":
p = new LogUpdatePattern(vulcanPackage, parentContainer);
p.Emit(patternNavigator);
break;
case "Container":
p = new ContainerPattern(vulcanPackage, parentContainer);
p.Emit(patternNavigator);
break;
case "FileSystemTask":
p = new FileSystemTaskPattern(vulcanPackage, parentContainer);
p.Emit(patternNavigator);
break;
case "ExecuteSQL":
p = new ExecuteSQLPattern(vulcanPackage, parentContainer);
p.Emit(patternNavigator);
break;
case "FactTable":
p = new FactTablePattern(vulcanPackage, parentContainer);
p.Emit(patternNavigator);
break;
case "ExecutePackage":
p = new ExecutePackagePattern(vulcanPackage, parentContainer);
p.Emit(patternNavigator);
break;
case "FTPTask":
p = new FTPTaskPattern(vulcanPackage, parentContainer);
p.Emit(patternNavigator);
break;
default:
break;
}
}
catch (System.Runtime.InteropServices.COMException ce)
{
Message.Trace(Severity.Error, ce, "Exception in Pattern {0}\n {1}\n", patternNavigator.Name, ce.Message);
}
catch (Exception e)
{
Message.Trace(Severity.Error, e, "Exception in Pattern {0}\n {1}\n", patternNavigator.Name, e.Message);
}
return(p);
}
public FileSystemTaskPattern(Packages.VulcanPackage vulcanPackage, DTS.IDTSSequence parentContainer)
:
base(vulcanPackage, parentContainer)
{
}
public FTPTask(
Packages.VulcanPackage vulcanPackage,
string name,
string taskDescription,
DTS.IDTSSequence parentContainer,
string serverName,
string port,
string userName,
string password,
string remotePath,
bool isRemotePathVariable,
string localPath,
bool isLocalPathVariable,
Microsoft.SqlServer.Dts.Tasks.FtpTask.DTSFTPOp operation
)
:
base(
vulcanPackage,
name,
taskDescription,
parentContainer
)
{
fTPTask = (DTS.TaskHost)parentContainer.Executables.Add("STOCK:FTPTask");
fTPTask.Name = name;
fTPTask.Description = taskDescription;
this.Task.Operation = operation;
this.Task.IsRemotePathVariable = isRemotePathVariable;
this.Task.IsLocalPathVariable = isLocalPathVariable;
Connection fTPServerConnection = new Connection(vulcanPackage, serverName, serverName, "FTP", String.Format("\"{0}:{1}\"", serverName, port));
fTPServerConnection.SetProperty("ServerUserName", userName);
fTPServerConnection.SetProperty("ServerPassword", password);
this.Task.Connection = fTPServerConnection.ConnectionManager.ID;
if (this.Task.IsRemotePathVariable == true)
{
this.Task.RemotePath = remotePath;
}
else
{
this.Task.RemotePath = remotePath;
}
if (this.Task.IsLocalPathVariable == true)
{
this.Task.LocalPath = localPath;
}
else
{
Connection localConnection = new Connection(vulcanPackage, localPath, localPath, "File", String.Format("\"{0}\"", ExpressionPathBuilder.EscapeBackslashes(localPath)));
int intFileUsageType = 2;
switch (operation)
{
case Microsoft.SqlServer.Dts.Tasks.FtpTask.DTSFTPOp.Send:
intFileUsageType = 0;
break;
case Microsoft.SqlServer.Dts.Tasks.FtpTask.DTSFTPOp.Receive:
intFileUsageType = 2;
break;
default:
intFileUsageType = 2;
break;
}
localConnection.SetProperty("FileUsageType", intFileUsageType);
this.Task.LocalPath = localPath;
}
}
public PrecedenceConstraint(Packages.VulcanPackage vulcanPackage, string from, string to, DTS.IDTSSequence parentContainer)
:
base(
vulcanPackage,
from + "_" + to,
"",
parentContainer
)
{
this.from = from;
this.to = to;
}
public ContainerPattern(Packages.VulcanPackage vulcanPackage, DTS.IDTSSequence parentContainer)
:
base(vulcanPackage, parentContainer)
{
_sequenceContainer = null;
}
public ContainerPattern(Packages.VulcanPackage vulcanPackage, DTS.IDTSSequence parentContainer)
: base(vulcanPackage,parentContainer)
{
_sequenceContainer = null;
}