Creating Temporary Tables using Batch File or SSIS Package in SQL Server

Question

I am trying to create Temp Table using SQL command in SQL Server Management studio. The SQL Command script when called through Batch File executes successfully but I cannot see tables being created. The same SQL command when I run in SSMS, creates temp tables and I can see them and use them. I am using below command to call SQL Script using batch file:

SQLCMD -S server -d Database -U "Username" -P "Pswd"  -i "C:\Users\kj\Query.sql"   

I tried to create the Temp Tables using SSIS package. Similar thing is going on . The execution of package states that Temp Tables are created successfully. But I cannot see it on SQL Server.

Please help.