"Invalid Pointer" error

• JMI

  SSChampion

  Points: 11831

  More actions

  October 27, 2004 at 10:10 am

  #60474

  I have a DataPump Task inside of which I need to make a decision which table records to transfer.

  I have two input parameters in this Task:

  gv_mbvarCOBDate

  gv_configCOBDate

  Here is the code of the Task:

  ------------------------------------------------------------------------

  DECLARE

  @INTERVAL_ID smallint,

  @mbvarCOBDate smalldatetime,

  @configCOBDate smalldatetime

  SELECT @mbvarCOBDate = ?  --Parameter 1

  SELECT @configCOBDate = ? --Parameter 2

   

  SELECT INTERVAL_ID INTO #INTERVAL_ID FROM INTERVAL

  WHERE

  (METHOD = 'STANDARD' AND EFFECTIVE <= @mbvarCOBDate AND EXPIRY >= @mbvarCOBDate)

  OR

  (METHOD = 'STANDARD' AND EFFECTIVE <= @configCOBDate AND EXPIRY >= @configCOBDate)

            

  SELECT --COV

  C.INTERVAL_ID,

  C.RF_ID1,

  C.RF_ID2,

  C.AMOUNT,

  C.CAPTURE_DATE

  FROM

  GlobalAnalytics2.dbo.COV C,

  GlobalAnalytics2.dbo.RF_INDEX RF1,

  GlobalAnalytics2.dbo.RF_INDEX RF2

     

  WHERE

  C.INTERVAL_ID IN (SELECT INTERVAL_ID FROM #INTERVAL_ID) and

  RF1.RF_ID = C.RF_ID1 and

  RF2.RF_ID = C.RF_ID2 and

  RF1.RF_ID in

  (SELECT RF_ID

  FROM GlobalAnalytics2.dbo.RF_INDEX

  WHERE

  (ASSET_TYPE = 'EQUITY' and PARAM_TYPE IN ('IMPLIED','BASE'))

  or

  (ASSET_TYPE = 'IR' and PARAM_TYPE = 'BASE')

  or

  (ASSET_TYPE = 'IR' and PARAM_TYPE = 'SPREAD' and RISK_CLASS = 'CREDIT')

  or

  (ASSET_TYPE = 'FX' and PARAM_TYPE = 'BASE'))

  and

  RF2.RF_ID in

  (SELECT RF_ID

  FROM GlobalAnalytics2.dbo.RF_INDEX

  WHERE

  (ASSET_TYPE = 'EQUITY' and PARAM_TYPE IN ('IMPLIED','BASE'))

  or

  (ASSET_TYPE = 'IR' and PARAM_TYPE = 'BASE')

  or

  (ASSET_TYPE = 'IR' and PARAM_TYPE = 'SPREAD' and RISK_CLASS = 'CREDIT')

  or

  (ASSET_TYPE = 'FX' and PARAM_TYPE = 'BASE'))

  DROP TABLE #INTERVAL_ID

  ------------------------------------------------------------------------

  Ehen I execute this Step it runs 10-12 seconds and then thows an error:

  Error Decription: Invalid Pointer

  DTS Designer did not allow me to do the transformations, so I first inserted SELECT * FROM COV. Then Tranmsformations were OK. Then I went to "Disconnected Edit" and changed the SOURCE to the script above.

  Do I get that error maybe because the script creates a temporary table and I don't have "CREATE.." permissions for that Connection?

  What's this "Invalid Pointer"?

• November 1, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Andrey-320088

  SSC Enthusiast

  Points: 147

  More actions

  May 18, 2006 at 12:57 pm

  #638844

  Just had this error.  Add a set nocount on/off and comment out any print statements.