/// <summary>
/// Creates temporary table
/// </summary>
/// <param name="tempTableName">temporary table name</param>
public void CreateTempTable(string tempTableName)
{
IDTSInput100 input = _componentMetaData.InputCollection[Constants.INPUT_NAME];
string templateCreateTempTable = SqlCreator.GetCreateTempTable(_IsagCustomProperties, Constants.TEMP_TABLE_PLACEHOLDER_BRACKETS);
string sqlCreateTempTable = templateCreateTempTable.Replace(Constants.TEMP_TABLE_PLACEHOLDER_BRACKETS, tempTableName);
if (!_IsagCustomProperties.UseBulkInsert)
{
SqlExecutor.ExecSql(sqlCreateTempTable, _bulkConn, _IsagCustomProperties.TimeOutDb, _dbTransaction);
}
}
/// <summary>
/// Executes pre- oder post execute command
/// </summary>
/// <param name="cmdType"> Events.IsagEventType.PreSql oder Events.IsagEventType.PostSql </param>
private void ExecPreOrPostExecuteStatement(IsagEvents.IsagEventType cmdType)
{
string sql = "";
string cmdTypeName = "";
try
{
if (cmdType == IsagEvents.IsagEventType.PreSql && _IsagCustomProperties.HasPreSql)
{
sql = _dbCommand.GetExecuteStatementFromTemplate(_IsagCustomProperties.PreSql);
cmdTypeName = "PreSql";
}
else if (cmdType == IsagEvents.IsagEventType.PostSql && _IsagCustomProperties.HasPostSql)
{
sql = _dbCommand.GetExecuteStatementFromTemplate(_IsagCustomProperties.PostSql);
cmdTypeName = "PostSql";
}
else if (cmdType != IsagEvents.IsagEventType.PreSql && cmdType != IsagEvents.IsagEventType.PostSql)
{
throw new Exception("Unknown CommandType in ExecPrePostExecuteStatement: " + cmdType);
}
// execute pre- oder post execute command
if (sql.Length > 0)
{
SqlTransaction transaction = _IsagCustomProperties.UseMultiThreading ? null : _txAll.Transaction;
int rowsAffected = SqlExecutor.ExecSql(sql, Conn, _IsagCustomProperties.TimeOutDb, transaction);
_events.Fire(IsagEvents.IsagEventType.Sql,
"[ExecSql:" + cmdType.ToString() + "]: {0} rows were affected by the Sql Command.",
new string[] { rowsAffected.ToString(), ((int)cmdType).ToString() });
_events.Fire(cmdType, cmdTypeName + " Statement has been executed.");
}
}
catch (Exception ex)
{
_events.FireError(new string[] { cmdTypeName, ex.Message });
throw;
}
}