Post reply

Possible to determine the datetime range of loaded data to staging table?

  • December 28, 2012 at 8:21 am

    #1572131

    My solution handles too

  • January 2, 2013 at 12:47 am

    #1572752

    SatishAyyar (12/28/2012)

    My solution handles too

    Hi satish,

    I tried out your solution, it does not met my requirement. I guess your solution take 73 hrs before my current sys date time. This is not what i want. The start time should be 73 hours ago from the end time while the end time is the nearest 8am(past). Thanks anyway. Btw if u are not sure what i am talking about, kindly study the scenarios. Thanks for the input

  • January 2, 2013 at 12:49 am

    #1572753

    Phil Parkin (12/28/2012)

    i wonder if you all took care of scenario whereby package i executed before or at 8am.

    My solution handles that.

    From what i see, phil your solution will definitely work. However i prefer doing it in conditional split for this. Do not how to convert ur tsql into conditional split expression

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply