SQL Server Performance

Invalid Pointer

Discussion in 'SQL Server DTS-Related Questions' started by danny123, May 17, 2007.

  1. danny123 New Member

    hi there,

    i am having issue with dts. i am importing data between 2 servers.
    "Sorurce : Microsoft Data Transformation Services (DTS) data pump
    invalid pointer"

  2. satya Moderator

    What type of data providers are these 2 server?
    If you are using a TSQL or SP then use SET NOCOUNT ON at the start of the procedure.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. danny123 New Member

    I got the solution..

    The query was issuing warnings and thats why it was giving errors.
    I just added set ansi_warnings off
    and it worked fine.

    Thanks for reply
  4. 1ANGO New Member

    is it advisable to use set ansi_warnings off? :)
  5. anandchatterjee New Member

    But in the query if you are refering any linked server then <set ansi_warnings off> returns error.. It doesn't set on that time!!
  6. satya Moderator

    1ANGO on what aspects you are referring?

Share This Page