DTS package passing variable rowset

• Dan Ball

  Newbie

  Points: 7

  More actions

  November 15, 2005 at 7:29 am

  #68509

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

• Don Staten

  SSC Eights!

  Points: 957

  More actions

  November 21, 2005 at 7:10 am

  #604925

  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.