SQL Server 2008 – Import/Export wizard not allowing Create Temp Table
I had a requirement to export the data from SQL Server to Oracle using SQL Server Import/Export wizard. In the SQL Server, I have created a SQL Script that fetch the required data that I need to export in Oracle database.
Because of some business logic, in the select script I have introduced the temp table. Now when I try export that data using select script that contain the local temp table the following error occurred.
Import-Export wizard not allowing Create Table #temp
Now if I removed that temp table from select script then it works fine. I also tried with global temp table. But the same error occurred.
It seems Import/Export wizard does not allow creating temp table.
If anybody have experience about this then please share as comment.
