DFT SSIS ISSUE

• h.singh10

  Right there with Babe

  Points: 731

  More actions

  January 16, 2012 at 11:17 am

  #251410

  I have two task in DFT 1.EXECUTE SQL TASK 2. DATA FLOW TASK.

  In data flow task, there is an oledb source that extract data from oracle and load into flat file.

  In execute sql task, I am logging the sysdate in oracle table like: insert into logging values(sysdate)

  In the next step, I am using a source query which extract data from test table as:

  select * from test where load_tmstp between (select max(tmspt) from batch) and sysdate

  Now here is the issue, i dont want to use the current value os sysdate but want to have the same value as we did in execute sql task (insert into logging values(sysdate))

  As going from execute sql task to dft, the value of sysdate will change.

  Is there any way, i can freeze that value and use that value later in the package.

  Thanks

  Harry

• herladygeekedness

  SSCertifiable

  Points: 5878

  More actions

  January 18, 2012 at 9:03 am

  #1435333

  Probably you can store it in a variable.