Invalid Object Name '#ABCIndexTemp'.

Hi all

I am writting a visual studio application using C#. when i try to insert bulk, i got this exception:


Invalid object name '#ABCIndexTemp'.
source: .Net SqlClient Data Provider
$exception.StackTrace:

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at Coredge.RecordDigger.RDConn.Conn.TryExecuteNonQuery(String query) in C:Record DiggerRDConnClassesConn.cs:line 4755



private bool TryExecuteNonQuery(string query)

{ //query = BULK INSERT #ABCIndexTemp' FROM 'C:\abc\test\FTRes.txt'


this._error = string.Empty;

using (System.Data.SqlClient.SqlCommand command = CreateCommand())

{


command.CommandText = query;

System.Data.SqlClient.SqlTransaction sqlTran = null;

try

{


tryOpenConn();

sqlTran = this._conn.BeginTransaction();

command.Transaction = sqlTran;

command.ExecuteNonQuery(); // <- Her I got the error

sqlTran.Commit();

return true;

}

catch (Exception ex)

{


this._error = GetInnerException(ex);

System.Diagnostics.Trace.WriteLine(this._error, "TryExecuteNonQuery " + query);

sqlTran.Rollback();

throw ex;
}

finally

{


sqlTran.Dispose();

CloseConnection();

}

}

}

Thanks in Advance

Khayralla