DTS dynamic query

• edevries

  Valued Member

  Points: 54

  More actions

  January 9, 2002 at 2:03 am

  #104646

  Hi,

  I have a working DTS package, it queries a remote Oracle server and transfers the data into a new table on the SQL 2000 server.

  But the query I have is static, it is something like:

  select SALES_WEEK_ID "Sales Week",

  LOC_ID "Location",

  ITEM "Item",

  from loc_item_week

  where sales_week_id in('200201')

  order by ...

  I now need to have the sales_week_id dynamic, on sunday the new weeks starts.

  Is there a way to make this value come from a table based on the date?

  Or could you point me to the right direction so I can search.

  Thanks in advance,

  Eduard de Vries

  
  Eduard de Vries

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  January 9, 2002 at 10:27 am

  #422004

  Use the dynamic properites task to alter the query. You can write a SQL statement to build this query.

  Steve Jones

  steve@dkranch.net