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
SELECT * from @.table is executed to get the results. I need these results
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
converted the table to @.table datatype and now the DTS can see the
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 Developertry SET NOCOUNT ON at the start of the procedure.
I'm not sure your situation but sounds what i experience before
Hope that help.
"JP" <JP@.discussions.microsoft.com> wrote in message
news:3D2B9092-7DC8-4FCB-810C-923E4EA7EF09@.microsoft.com...
> 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
> SELECT * from @.table is executed to get the results. I need these results
> 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
> converted the table to @.table datatype and now the DTS can see the
> 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|||
"JP" wrote:

> 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 la
st
> SELECT * from @.table is executed to get the results. I need these results
> 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
> converted the table to @.table datatype and now the DTS can see the
> 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|||Andy Warren posted this reply which may help.
By: Andy Warren
Email : awarren@.cfl.rr.com
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)
"Atenza" wrote:

> 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.
> "JP" <JP@.discussions.microsoft.com> wrote in message
> news:3D2B9092-7DC8-4FCB-810C-923E4EA7EF09@.microsoft.com...
> last
> I
> I
>
>