Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2011

    Unanswered: Problem with ssis variables

    Hi all

    I am trying to capture sysdate in a variable and then use this variable further in the package.

    I have one execute sql task which is connected further to data flow task.

    In execute sql task:

    Insert into logging (sysdate)

    Now after that in data flow task, i am using a oledb source which extract data from oracle.

    select * from table1 where timestamp between max(tmstp) and sysdate.

    I dont want sysdate in the above query as it changes every second. I want to get the same sysdate that was used in execute sql task fro logging purpose. Can we store that value in a variable and if so, can we use it the above query.



  2. #2
    Join Date
    Jan 2007
    Provided Answers: 10
    I haven't tinkered with SSIS in a wee while and don't have a copy to hand but I can point you in the right direction to get you started.

    Under the SSIS menu there is an option titled Variable

    You'll need to create a new variable and set the scope to package level or global level (whichever you feel is most appropriate).

    Then have a google around for ways to set and use SSIS variables.

    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts