Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Dynamically hourly data extraction in SSIS 2012 RE: Dynamically hourly data extraction in SSIS 2012

  • December 6, 2014 at 12:05 am

    #1763104

    BI_NewBie (12/1/2014)

    Hi,

    Thanks for the reply.

    May be i have not cleared my question properly.

    My transaction system has huge data and i have asked to pull the data of last 2 months in my database. For that i have designed an ETL.

    below is the way i am pulling the data

    Select * from table

    where date >= '2014-10-01 11:00:00' and date < '2014-10-01 16:00:00'

    Now my problem is i dont want to hardcode date range since the data is of 2 months. i want to make dynamic package which automatically pick the date range of every 4 hours starts from Oct to till date.

    Thanks a lot !!

    I guess I just don't understand the need for going anywhere near SSIS for this.

    And you keep saying your dataset is huge but what is "huge"? How many rows and columns and average row length are we talking about here?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)