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

  • maida_rh (12/17/2012)


    Ok...waiting for an helpful repli which will be a treat for me......

    msdb...database is in SQL data folder but dont know how to restore packages and got a link which helped me in this:

    I also need to update 2008 r2 database with sql server 2000 database is i possible ?any pros and cons due to that?

    I'm not quite sure what you meant by your last statement. Do you need to update a SQL 2000 database to SQL 2008? or vice versa? The latter doesn't happen, but the former is at least in part, fairly simple, in terms of getting a copy of the MDF and LDF files and then ATTACH those on the SQL 2008 instance. However, before you do that, be sure that everything that USES the database can either handle SQL 2008, as there are no doubt a number of old constructs that would work in SQL 2000, but have been deprecated since then and no longer operate in SQL 2008, even with the compat mode of the db set to SQL 2000 (80 vs. 100). There can be a potentially large volume of compatibility work to handle, so you'll need to search for those features that have been deprecated. I don't have a link handy or I'd share it, so you'll have to search for that, or perhaps someone else will have one, or know where to get one.

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