DTS package passing variable rowset

  • 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 (?)

  • This was removed by the editor as SPAM

  • 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