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