Post reply

Tools for undertaking data transformations from multiple locations

  • March 13, 2008 at 7:59 am

    #70882

    I am looking for a tool that allows data from files other databases to be mapped into a central database. this would allow the data to be moved from one location to another. This would also support relationships in the moving process.

    I need to be able to move data from both databases (SQL Server Express), and from csv files to a SQL Server Database.

    I need a tool that can be scheduled to run at different times against different locations, and must be able to remove the initial data as it goes.

    If anybody has any suggestions, I'd appreciate it.

  • March 13, 2008 at 9:30 am

    #789148

    Do you have full version of SQL server or only express? SSIS is designed for exactly this purpose. Look in BOL on how to use it.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • March 13, 2008 at 9:31 am

    #789150

    Are you looking for a tool other than DTS? I assume you know that DTS is capable of doing all you've described.

    Greg

  • March 13, 2008 at 11:03 am

    #789216

    BCP or a Proc run by CmdShell with a BULK INSERT in it. Both can be scheduled by the Windows Task Scheduler.

    --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)

Viewing 4 posts - 1 through 4 (of 4 total)

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