Post reply

Continuously running SSIS Package

  • August 18, 2011 at 12:08 pm

    #242319

    Hi ,

    I am planning to create a continuously running SSIS package. Idea is to extract data from 80 different geographical locations.Each of them have foxpro database. My project is to centralize them. Any advice on , is this good idea ..?

    Thank in advance.

  • August 18, 2011 at 2:27 pm

    #1370402

    Please provide more info. How much data, how frequently and why continuously? You make it sound like a migration, rather than something which needs to run over and over again. Will the centralised database replace the others? If not, what is the point?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • August 18, 2011 at 2:45 pm

    #1370413

    Hi Phil,

    This project is to integrate distributed foxpro database and create a real time, online centralized data repository. So we can have a clear overall picture of what is happening in the organization.( Foxpro db is the billing system,invoices)

    1. Why continuously:So I need to extract data from all the distributed locations continuously 24x7.

    2. How frequently : every 3 mins (at least, smaller the better )

    3. This is not a migration. No system , db is getting replaced /Upgraded. Just creating centralized repository.

    4. I did the system analysis. Number of extraction will be 2000 records per minutes (from all 80 locations).

    eg: need to write 2000 records per min to the centralized location.

    Source files are (dbf) just over 300 MB.

    I hope this clarifies the scenario.

    Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

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