Invalid Pointer | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Invalid Pointer

I have an error when I try to run a transformation within SQLServer 2000. I’m just learning how to use it as I am an Oracle DBA (Don’t hold that against me) by trade. I want to test the DTS functionality with a simple DTS package. Basically I want to aggregate two columns on one table and put the result into another table. My first table is in MasterDB and is called craigtest1. It has an order_id to join on and two further columns called col1 and col2. They hold values 1 and 2 respectively. The second table is in tempdb and is called craigtest2 and holds two columns, one called order_id and a blank column called col1. Both order_id columns contain the value 1. All columns are of type int. I run the following query… update tempdb.dbo.ceptest2 set col1 = a.col1+a.col2 from master.dbo.ceptest1 a, tempdb.dbo.ceptest2 b where b.order_id = a.order_id When I run this in query analyser it runs perfectly but, when I run it in DTS I get invalid pointer error – can you help? I see from the internet that the error seems reasonably common (Google lead me to your site actually) but, I don’t see how many people fix it. Many thanks for any help you can give

I dont think this wil make a difference at all, but try it. update b set col1 = a.col1+a.col2
from master.dbo.ceptest1 a join tempdb.dbo.ceptest2 b on b.order_id = a.order_id Also, in dts, how was your connection setup? What are the connection properties? What type of DTS task are you running this in?
Can you provide exactly error?.
Thanks Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
quote:Originally posted by LuisMartin Can you provide exactly error?.
Thanks Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

Hi Luis The exact error is "Invalid pointer" Cheers Craig
For reasons I’m not sure of, but is worth trying, begin your dts command with set nocount on
update tempdb.dbo.ceptest2 set col1 = a.col1+a.col2 from master.dbo.ceptest1 a, tempdb.dbo.ceptest2 b where b.order_id = a.order_id
I think somehow its trying to store the rowcount value returned somewhere in the new table. I’ve seen it fix this error in the past.
Refer as specified by Chris to overcome the issue.
Ensure the SQL is equipped with latest service pack fixes. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
quote:Originally posted by sussudio I have an error when I try to run a transformation within SQLServer 2000. I’m just learning how to use it as I am an Oracle DBA (Don’t hold that against me) by trade. I want to test the DTS functionality with a simple DTS package. Basically I want to aggregate two columns on one table and put the result into another table. My first table is in MasterDB and is called craigtest1. It has an order_id to join on and two further columns called col1 and col2. They hold values 1 and 2 respectively. The second table is in tempdb and is called craigtest2 and holds two columns, one called order_id and a blank column called col1. Both order_id columns contain the value 1. All columns are of type int. I run the following query… update tempdb.dbo.ceptest2 set col1 = a.col1+a.col2 from master.dbo.ceptest1 a, tempdb.dbo.ceptest2 b where b.order_id = a.order_id When I run this in query analyser it runs perfectly but, when I run it in DTS I get invalid pointer error – can you help? I see from the internet that the error seems reasonably common (Google lead me to your site actually) but, I don’t see how many people fix it. Many thanks for any help you can give

This error is now resolved, thank you to everyone who helped…
]]>