using sp as Source

#1

Hi,
I am trying to use a stored proc as a source for a data transformation.
This sp uses temp tables. When I preview the data everything is fine.

But when I try to map the transformations I get an error "Invalid object
name" saying the temp table does not exist...

What should I do?

Thanks

#2

fleo,

Insert SET NOCOUNT ON statement at the beginning of the stored procedure.

Ilya

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

Quote:

Hi,
I am trying to use a stored proc as a source for a data transformation.
This sp uses temp tables. When I preview the data everything is fine.

But when I try to map the transformations I get an error "Invalid object
name" saying the temp table does not exist...

What should I do?

Thanks

#3

Hi Ilya,
The NOCOUNT option is already set.

"Ilya Margolin" a écrit :

Quote:

fleo,

Insert SET NOCOUNT ON statement at the beginning of the stored procedure.

Ilya

"fleo" <fleo (AT) discussions (DOT) microsoft.com> wrote in message
news:2E23454F-BBE2-4526-9EDA-1A4DB6AA7AEE (AT) microsoft (DOT) com...
Hi,
I am trying to use a stored proc as a source for a data transformation.
This sp uses temp tables. When I preview the data everything is fine.

But when I try to map the transformations I get an error "Invalid object
name" saying the temp table does not exist...

What should I do?

Thanks

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

using sp as Source

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

using sp as Source - 11-03-2005 , 04:10 PM

Re: using sp as Source - 11-07-2005 , 08:31 AM

Re: using sp as Source - 11-08-2005 , 10:23 AM