Automation Process

  • Hi guys,

    THanks for taking time to comming to this thread and any suggestion is appreciated.

    We have clients databases with HR data in sql server 2000. Presently, we use DTS packages (every client has his own package) to update their HR feed every month. What should be the best practice so that burden is minimized from our data-team? The file format sent by the clients are usually text files, but the columns may differ per clients' need. However, the database structure for all clients are same. Any suggestion on this is greatly appreciated.

    Thanks,

    SB

  • Load the text files to a permanant temp table using bulk insert...and insert required data from temp table to main table....

     

    MohammedU
    Microsoft SQL Server MVP

  • Coming out this week: http://www.sqlservercentral.com/columnists/mBalasundram/2925.asp

    I'd use separate DTS packages for each client as an easy way to implement things for your team and train others on how to maintain them. More admin work if your core structure changes, nut not that much more unless we're talking 10s or 100s of clients.

  • Steve thanks for the response. We are talking about 200 clients. Any suggestion. Thanks!

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

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