SQL Server 2008 – Import/Export wizard not allowing Create Temp Table

SQL, SQL-Advanced, SQL-SSIS, Varinder Sandhu

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

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.

facebookShare on Facebook
TwitterPost on X
FollowFollow us
PinterestSave
, ,