Cannot create a temp table

#1

I am unable to create a temp table in DTS using the Execute SQL Task.

I have tried: CREATE TABLE #Test(Col1 varchar(5), Col2 varchar(5))
and CREATE TABLE ##Test(Col1 varchar(5), Col2 varchar(5))

The connection is pointed to Tempdb on the server I am using.
When I click execute I get a success dialog box but it does not create the
table.
Does anyone have any suggestions?

#2

Can you run this statement with the same user in Query Analyzer? It looks
like a security issue.

Rick

"MNDiver" <MNDiver (AT) discussions (DOT) microsoft.com> wrote

Quote:

I am unable to create a temp table in DTS using the Execute SQL Task.

I have tried: CREATE TABLE #Test(Col1 varchar(5), Col2 varchar(5))
and CREATE TABLE ##Test(Col1 varchar(5), Col2 varchar(5))

The connection is pointed to Tempdb on the server I am using.
When I click execute I get a success dialog box but it does not create the
table.
Does anyone have any suggestions?

#3

Thanks for the reply Rick. I tried it on a server where I have sa rights and
still no good. I can create the table in Query Analyzer on either server with
no problem. Is there a bug in DTS or EM that would cause this?

"Rick Gittins" wrote:

Quote:

Can you run this statement with the same user in Query Analyzer? It looks
like a security issue.

Rick

"MNDiver" <MNDiver (AT) discussions (DOT) microsoft.com> wrote in message
news:582FB8B0-1750-49AF-9DAF-AAEE610AE8D5 (AT) microsoft (DOT) com...
I am unable to create a temp table in DTS using the Execute SQL Task.

I have tried: CREATE TABLE #Test(Col1 varchar(5), Col2 varchar(5))
and CREATE TABLE ##Test(Col1 varchar(5), Col2 varchar(5))

The connection is pointed to Tempdb on the server I am using.
When I click execute I get a success dialog box but it does not create the
table.
Does anyone have any suggestions?

#4

It's not a bug because I have been able to do it.

Is the user that is logged into Query Analyzer the same that you are logging
into EM?

Rick

"MNDiver" <MNDiver (AT) discussions (DOT) microsoft.com> wrote

Quote:

Thanks for the reply Rick. I tried it on a server where I have sa rights
and
still no good. I can create the table in Query Analyzer on either server
with
no problem. Is there a bug in DTS or EM that would cause this?

"Rick Gittins" wrote:

Can you run this statement with the same user in Query Analyzer? It
looks
like a security issue.

Rick

"MNDiver" <MNDiver (AT) discussions (DOT) microsoft.com> wrote in message
news:582FB8B0-1750-49AF-9DAF-AAEE610AE8D5 (AT) microsoft (DOT) com...
I am unable to create a temp table in DTS using the Execute SQL Task.

I have tried: CREATE TABLE #Test(Col1 varchar(5), Col2 varchar(5))
and CREATE TABLE ##Test(Col1 varchar(5), Col2 varchar(5))

The connection is pointed to Tempdb on the server I am using.
When I click execute I get a success dialog box but it does not create
the
table.
Does anyone have any suggestions?

#5

Yes, I am logged into both EM and QA as the same user.

"Rick Gittins" wrote:

Quote:

It's not a bug because I have been able to do it.

Is the user that is logged into Query Analyzer the same that you are logging
into EM?

Rick

"MNDiver" <MNDiver (AT) discussions (DOT) microsoft.com> wrote in message
news:9DAD4ED2-5FCF-416A-BDF2-76DBD013D003 (AT) microsoft (DOT) com...
Thanks for the reply Rick. I tried it on a server where I have sa rights
and
still no good. I can create the table in Query Analyzer on either server
with
no problem. Is there a bug in DTS or EM that would cause this?

"Rick Gittins" wrote:

Can you run this statement with the same user in Query Analyzer? It
looks
like a security issue.

Rick

"MNDiver" <MNDiver (AT) discussions (DOT) microsoft.com> wrote in message
news:582FB8B0-1750-49AF-9DAF-AAEE610AE8D5 (AT) microsoft (DOT) com...
I am unable to create a temp table in DTS using the Execute SQL Task.

I have tried: CREATE TABLE #Test(Col1 varchar(5), Col2 varchar(5))
and CREATE TABLE ##Test(Col1 varchar(5), Col2 varchar(5))

The connection is pointed to Tempdb on the server I am using.
When I click execute I get a success dialog box but it does not create
the
table.
Does anyone have any suggestions?

#6

New day, new eyes. Found my error... referenced conneciton was to same db in
different server. Thanks for the assistance.

"Rick Gittins" wrote:

Quote:

It's not a bug because I have been able to do it.

Is the user that is logged into Query Analyzer the same that you are logging
into EM?

Rick

"MNDiver" <MNDiver (AT) discussions (DOT) microsoft.com> wrote in message
news:9DAD4ED2-5FCF-416A-BDF2-76DBD013D003 (AT) microsoft (DOT) com...
Thanks for the reply Rick. I tried it on a server where I have sa rights
and
still no good. I can create the table in Query Analyzer on either server
with
no problem. Is there a bug in DTS or EM that would cause this?

"Rick Gittins" wrote:

Can you run this statement with the same user in Query Analyzer? It
looks
like a security issue.

Rick

"MNDiver" <MNDiver (AT) discussions (DOT) microsoft.com> wrote in message
news:582FB8B0-1750-49AF-9DAF-AAEE610AE8D5 (AT) microsoft (DOT) com...
I am unable to create a temp table in DTS using the Execute SQL Task.

I have tried: CREATE TABLE #Test(Col1 varchar(5), Col2 varchar(5))
and CREATE TABLE ##Test(Col1 varchar(5), Col2 varchar(5))

The connection is pointed to Tempdb on the server I am using.
When I click execute I get a success dialog box but it does not create
the
table.
Does anyone have any suggestions?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Cannot create a temp table

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Cannot create a temp table - 07-19-2005 , 01:29 PM

Re: Cannot create a temp table - 07-19-2005 , 02:18 PM

Re: Cannot create a temp table - 07-19-2005 , 02:49 PM

Re: Cannot create a temp table - 07-19-2005 , 04:17 PM

Re: Cannot create a temp table - 07-20-2005 , 07:57 AM

Re: Cannot create a temp table - 07-20-2005 , 08:00 AM