SqlBulkCopy in to #temp table

[igorananda]

Hi VB .Net grurus!

After spending a fear amount of time I still can not find a way to upload data via SqlBulkCopy in to the #temp table.

Here is a sample code. What do I do wrong?

Dim sqlConn As SqlConnection = New SqlConnection("Server=FC;Integrated Security=SSPI")
sqlConn.Open()


Dim blukcopy As SqlBulkCopy = New SqlBulkCopy(sqlConn)


blukcopy.DestinationTableName = "tempdb..#table"
blukcopy.WriteToServer(dtLiveHoldings)

Thank you!
Igor.

 

[cjard]

Maybe the #temp table is being destroyed after the work is finished so there is no point using it?

temp table (#), global temp tables (##) and @table variables

Use a real table?