November 15, 2005 at 7:29 am
Hi,
I have a DTS package that does a query against a remote DB2 table on mainframe using DB2 connect and I would like to pass in a variable rowset or even loop through records to create a table. My table that I am getting rowset from is local to MS SQL 2000. I have tried using parameters but I am getting an error message Setparameterinfo has not been called. I have a execute SQL that puts a rowset into global variable but I can't seem to find a way of using it in my variable any help would be greatly appreaciated my remote SQL is
SELECT * FROM HESKDB2.CLAIM_HISTORY A
WHERE A.FISCAL_SERVICE_YR='2003' AND
FEE_PAID_AMT<>0 AND
HEALTH_NUMBER IN (?)
November 18, 2005 at 8:00 am
This was removed by the editor as SPAM
November 21, 2005 at 7:10 am
You may want to check out this article:
http://www.sqldts.com/default.aspx?298
You will need to use ActiveX scripting to get through the rowset global variable.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply