DTS Invalid pointer

SQL Server Developer >> DTS Invalid pointer

This continues from the tread DTS using #temp tables. I have a temp table
that gets populated through a really complex SP (with
selects/update/inserts). When all the processing is completed, the very last

pumped to an external text file on a nightly basis.

I started with #temp tables and couldn't get the DTS to see the table. So I

definitions.

When I execute the DTS step to pump the data to the text file I get the
error message: 'Invalid Pointer'. The DTS can see all the transforms and
objects in the SP, but I cannot figure this error. For whatever reason, if I
"Preview" the data in the DTS it will say no row set was returned. But
running it in Query Analyzer produces results.

I've been struggling with this for two days. Any further assistance is
appreciated.
--
JP
.NET Software Developer

SQL Server55

SQL Server Developer >> DTS Invalid pointer try SET NOCOUNT ON at the start of the procedure.
I'm not sure your situation but sounds what i experience before
Hope that help.

> This continues from the tread DTS using #temp tables. I have a temp table
> that gets populated through a really complex SP (with
> selects/update/inserts). When all the processing is completed, the very
last

> pumped to an external text file on a nightly basis.
>
> I started with #temp tables and couldn't get the DTS to see the table. So
I

> definitions.
>
> When I execute the DTS step to pump the data to the text file I get the
> error message: 'Invalid Pointer'. The DTS can see all the transforms and
> objects in the SP, but I cannot figure this error. For whatever reason, if
I
> "Preview" the data in the DTS it will say no row set was returned. But
> running it in Query Analyzer produces results.
>
> I've been struggling with this for two days. Any further assistance is
> appreciated.
> --
> JP
> .NET Software Developer

SQL Server Developer >> DTS Invalid pointer

> This continues from the tread DTS using #temp tables. I have a temp table
> that gets populated through a really complex SP (with
> selects/update/inserts). When all the processing is completed, the very last

> pumped to an external text file on a nightly basis.
>
> I started with #temp tables and couldn't get the DTS to see the table. So I

> definitions.
>
> When I execute the DTS step to pump the data to the text file I get the
> error message: 'Invalid Pointer'. The DTS can see all the transforms and
> objects in the SP, but I cannot figure this error. For whatever reason, if I
> "Preview" the data in the DTS it will say no row set was returned. But
> running it in Query Analyzer produces results.
>
> I've been struggling with this for two days. Any further assistance is
> appreciated.
> --
> JP
> .NET Software Developer

SQL Server Developer >> DTS Invalid pointer Andy Warren posted this reply which may help.

By: Andy Warren

Last Modified: 11/16/2001
The problem is that the query must be a single line of T-SQL code. Most
likely you have a "use " line before the query which will cause this error.

(Back to SQL Server 7.0/2000:DTS FAQs)

> try SET NOCOUNT ON at the start of the procedure.
> I'm not sure your situation but sounds what i experience before
> Hope that help.
>

> > This continues from the tread DTS using #temp tables. I have a temp table
> > that gets populated through a really complex SP (with
> > selects/update/inserts). When all the processing is completed, the very
> last

> > pumped to an external text file on a nightly basis.
> >
> > I started with #temp tables and couldn't get the DTS to see the table. So
> I

> > definitions.
> >
> > When I execute the DTS step to pump the data to the text file I get the
> > error message: 'Invalid Pointer'. The DTS can see all the transforms and
> > objects in the SP, but I cannot figure this error. For whatever reason, if
> I
> > "Preview" the data in the DTS it will say no row set was returned. But
> > running it in Query Analyzer produces results.
> >
> > I've been struggling with this for two days. Any further assistance is
> > appreciated.
> > --
> > JP
> > .NET Software Developer
>
>
>