Loading date depending on Date and Time

• Arman Khan

  SSC Eights!

  Points: 864

  More actions

  November 23, 2011 at 3:37 pm

  #251008

  All,

  I am working on creating an ssis package to move the data from one source to multiple destinations depending on Dates and Time for diffrent destinations.

  Can someone help in setting up Variable or Expression which i can use to specify time. e.g i need to move the data from Yesterday 7:00 AM to Today 7:00 AM.

  My major problem is to setup time not the date but if you have better solution for both i will take it..

  Thanks..Ad

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  November 23, 2011 at 3:48 pm

  #1412505

  Not sure how to do it is SSIS off the top of my head, but if you use a SQL Task to do the work for you the following should help:

  select dateadd(hh, 7, dateadd(dd, datediff(dd, 0, getdate()) - 1, 0)), dateadd(hh, 7, dateadd(dd, datediff(dd, 0, getdate()), 0))