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

  • We need a little more detail here... You stated that the "Package execute successfully", but didn't specify what process was used to do so, e.g. SSIS, DTS, a SQL Agent Job, a VBScript invoking the DTSEXEC.EXE program, etc... You also didn't specify what process you were trying to use when you tried to execute the package. There are a number of differences between the various methods of executing a package, and security context is often different by default, so all kinds of "funny looking errors" can crop up when you try to run a package and the security context it tries to run with isn't the one it usually runs with. Let us know so we can help you more easily.

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