SQL Server Performance

Invalid Pointer

Discussion in 'SQL Server DTS-Related Questions' started by sussudio, Sep 28, 2004.

  1. sussudio New Member

    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
  2. ChrisFretwell New Member

    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?
  3. Luis Martin Moderator

    Can you provide exactly error?.
    Thanks

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  4. sussudio New Member

    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
  5. ChrisFretwell New Member

    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.
  6. satya Moderator

    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.
  7. sussudio New Member

    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...

Share This Page