DTS Error

• MostInterestingMan

  SSCertifiable

  Points: 6291

  More actions

  May 14, 2009 at 1:02 pm

  #97568

  Hi,

  I am using DTS to import data from a sql 2005 instance to a sql 2000 and gets the following error.

  "invalid pointer"

  Any help is greatly appreciated.

  Thanks

  MCTS: BI 2008, MCITP: BI 2008
  Stay Thirsty My Friends

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  May 14, 2009 at 2:25 pm

  #994892

  Are you using a stored procedure in the package? If so, this thread may help: http://www.sqlservercentral.com/Forums/Topic171035-9-1.aspx#bm341953

  Greg

• MostInterestingMan

  SSCertifiable

  Points: 6291

  More actions

  May 14, 2009 at 3:00 pm

  #994929

  Greg,

  Thanks a million. The info from the thread helped me resolve my issue. It was the USE command in had in my scripts.

  Francis

  MCTS: BI 2008, MCITP: BI 2008
  Stay Thirsty My Friends