public SsisVariable PeekStackVariable(string varName)
{
SsisVariable varRet = null;
if (_logStack.Any())
{
Dictionary <string, SsisVariable> TopVariables = _logStack.Peek();
if (TopVariables.ContainsKey(varName))
{
varRet = TopVariables[varName];
}
}
return(varRet);
}
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);
}
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);
}
