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

  • I meant updating sql server 2008 R2 database with sql server 2000 (i.e. 2000 >2008) ?

    I successfully restore the 2000 database into 2008 but what i need to know is a method to update 2008 database when ever change occur and using restoring for that is not a goog idea (I think !).what do u say ?

    Can i use DTs packages in 2000 to achieve that but 2008 didn't support DTs ?