Home Forums SQL Server 2008 SQL Server 2008 - General Error :The Data Pump Task requires Transformation to be specified while executing DTs packages RE: Error :The Data Pump Task requires Transformation to be specified while executing DTs packages

  • It sounds like you have a SQL 2000 database that you backed up on SQL 2000 and restored on SQL 2008, then you want updates to the 2000 database to make it into the 2008 database as they occur. To do it in real time, you'd need to set up replication or log shipping, and I don't recall if the latter is supported by SQL 2000 or not, but you can probably find that answer easily enough. With any other method, you have to live with some level of out of sync. Have I at least accurately described your objective?

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)