Problem:

I`m using the SQL server 7.0 Data Transformation Packages.
I`m trying to migrate some data from Oracle server to SQL (fixed interval)
I would like to use the result from one SQL task in the `where` clause of
the transformation.
I already tried by declaring global package variables but that does not
work.
Included the SQL Scripts and the graphical DTS Package.

Hints ????


SQL TASK 1
********************

set quoted_identifier OFF

if exists (select * from sysobjects where id =
object_id(N`[dbo].[PLAN_T1_ORDERS]`) and OBJECTPROPERTY(id, N`IsUserTable`)
= 1)
drop table [dbo].[PLAN_T1_ORDERS]

CREATE TABLE [dbo].[PLAN_T1_ORDERS] (
[T1_PRODUCT_LINE] [varchar] (2) NULL ,
[T1_YEAR] [numeric](2, 0) NULL ,
[T1_PERIOD] [numeric](2, 0) NULL ,
[T1_WEEK] [numeric](2, 0) NULL ,
[T1_ORDERNUMBER] [numeric](3, 0) NULL ,
[T1_ITEMCODE] [varchar] (6) NULL ,
) ON [PRIMARY]

*******************

SQL TASK 2
*******************

SELECT T9_JAAR, T9_PERIODE, T9_WEEK FROM PLAN_T9_DATE
where t9_date = convert(char(10),getdate(),120)

*******************

TRANSFORMATION TASK 1
*******************

select T1_PRODUCT_LINE,T1_YEAR,T1_PERIOD,T1_WEEK,T1_ORDER NUMBER,T1_ITEMCODE
from "PLAN"."PLAN_T1_ORDERS", "MFOODS"."SOP_MASTER"
where T1_ITEMCODE = "MFOODS"."SOP_MASTER".ITEM_CODE and T1_YEAR = `98` and
T1_PERIOD = `7`

******************

How can I use the T9_JAAR, T9_PERIODE, T9_WEEK from SQl task 2 in the
Transformation task 1 so would look like...

*******************

select T1_PRODUCT_LINE,T1_YEAR,T1_PERIOD,T1_WEEK,T1_ORDER NUMBER,T1_ITEMCODE
from "PLAN"."PLAN_T1_ORDERS", "MFOODS"."SOP_MASTER"
where T1_ITEMCODE = "MFOODS"."SOP_MASTER".ITEM_CODE and T1_YEAR = T9_JAAR
and T1_PERIOD = T9_PERIODE and T1_WEEK = T9_WEEK