October 27, 2004 at 10:10 am
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
May 18, 2006 at 12:57 pm
Just had this error. Add a set nocount on/off and comment out any print statements.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply