public override SSISEmitterContext Emit()
{
this.UnSave();
this.Save();
SSISEmitterContext newContext = null;
try
{
Package logicalPackage = (Package)_logicalContainer;
this.DTSPackage.Variables.Add("_vulcanPackageRepositoryDirectory", false, "User", OutputBaseDirectory);
foreach (ConnectionConfiguration connection in logicalPackage.ConnectionConfigurationList)
{
this.AddConfiguration(connection.Name);
SsisConnection s = new SsisConnection(connection);
}
foreach (PackageConfiguration config in logicalPackage.PackageConfigurationList)
{
this.AddConfiguration(config.Name);
}
foreach (Variable variable in logicalPackage.VariableList)
{
SsisVariable s = new SsisVariable(variable);
}
this.Reload();
newContext = new SSISEmitterContext(this, new SsisSequence(this.DTSPackage, _logicalContainer), _context.PluginLoader);
this.DTSPackage.TransactionOption = (Microsoft.SqlServer.Dts.Runtime.DTSTransactionOption)
Enum.Parse(typeof(Microsoft.SqlServer.Dts.Runtime.DTSTransactionOption), this.LogicalPackage.TransactionMode);
EmitPatterns(newContext);
this.Save();
}
catch (Exception e)
{
this.Save();
MessageEngine.Global.Trace(Severity.Error, e, e.Message);
}
return(newContext);
}
public virtual void BindLogVariableAsOutputParameter(SsisVariable variable, int parameterIndex, System.Data.OleDb.OleDbType dataType)
{
BindParameter(variable.DTSVariable, DTSTasks.ExecuteSQLTask.ParameterDirections.Output, parameterIndex.ToString(), (int)dataType, 255);
}
public override SSISEmitterContext Emit()
{
this.UnSave();
this.Save();
SSISEmitterContext newContext = null;
try
{
Package logicalPackage = (Package)_logicalContainer;
this.DTSPackage.Variables.Add("_vulcanPackageRepositoryDirectory", false, "User", OutputBaseDirectory);
foreach (ConnectionConfiguration connection in logicalPackage.ConnectionConfigurationList)
{
this.AddConfiguration(connection.Name);
SsisConnection s = new SsisConnection(connection);
}
foreach (PackageConfiguration config in logicalPackage.PackageConfigurationList)
{
this.AddConfiguration(config.Name);
}
foreach (Variable variable in logicalPackage.VariableList)
{
SsisVariable s = new SsisVariable(variable);
}
this.Reload();
newContext = new SSISEmitterContext(this, new SsisSequence(this.DTSPackage, _logicalContainer), _context.PluginLoader);
this.DTSPackage.TransactionOption = (Microsoft.SqlServer.Dts.Runtime.DTSTransactionOption)
Enum.Parse(typeof(Microsoft.SqlServer.Dts.Runtime.DTSTransactionOption), this.LogicalPackage.TransactionMode);
EmitPatterns(newContext);
this.Save();
}
catch (Exception e)
{
this.Save();
MessageEngine.Global.Trace(Severity.Error, e, e.Message);
}
return newContext;
}
public virtual SSISEmitterContext Emit()
{
SSISEmitterContext newContext = _context.NewParentSequence(new SsisSequence(this.SequenceContainer, this._logicalContainer));
this.DTSSequenceContainer.TransactionOption = (Microsoft.SqlServer.Dts.Runtime.DTSTransactionOption)
Enum.Parse(typeof(Microsoft.SqlServer.Dts.Runtime.DTSTransactionOption), this._logicalContainer.TransactionMode);
//TODO: Hardcode the IsolationLevel to ReadCommitted. This will be changed to be customizable.
this.DTSSequenceContainer.IsolationLevel = System.Data.IsolationLevel.ReadCommitted;
foreach (Variable variable in _logicalContainer.VariableList)
{
SsisVariable s = new SsisVariable(variable, newContext);
}
EmitPatterns(newContext);
return newContext;
}
