Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Error :The Data Pump Task requires Transformation to be specified while executing DTs packages


Error :The Data Pump Task requires Transformation to be specified while executing DTs packages

Author
Message
maida_rh
maida_rh
SSC Rookie
SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)

Group: General Forum Members
Points: 46 Visits: 111
I need updation through Data transformation Packages.

I trying to update database with DTs packages and right know source and destination databases both are developed using sql serevr 2000 .

Package execute successfully but when i tried to execute it, an error occur:

The Data Pump Task requires Transformation to be specified ...

I checked the query it f9 but i couldn't find the error source Sad any suggestion to resolve it ?????
sgmunson
sgmunson
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2853 Visits: 3765
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)
Smile Smile Smile
Health & Nutrition
maida_rh
maida_rh
SSC Rookie
SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)

Group: General Forum Members
Points: 46 Visits: 111
I used DTs packages to update destination database and I simly execute it by selecting a package > right click >execute package.

Error occur due settings not done for Tranfer Data Task ....issue resolved Smile n thanks for repli

Can u guide me how to make backup of DTs packages in sql server 2000,As they are save in sql server and someone said they are in :

(msdb.dbo.sysdtspackages) where i can find it in sql serevr ..

kindly repli
sgmunson
sgmunson
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2853 Visits: 3765
There are a number of ways to execute a package, and as I haven't seen SQL 2000 in quite some time, I don't recognize your click sequence, so you'll have to specify exactly what software you were using to execute the package. There are two possible locations for a package: SQL Server, and the file system. Where exactly it's kept as a file, and where exactly it's kept within SQL Server aren't known to me, so I'll have to toss that question to folks who know more about SSIS than I do. I'm also fairly certain that even when stored in SQL Server, they exist as files somewhere in the installation directories. I'm not sure there's a need to back up the packages separately from a full backup of the server itself, but an extra copy might not be a bad thing as long where the copy is kept is as well documented as the normal backup process.

Steve
‌(aka sgmunson)
Smile Smile Smile
Health & Nutrition
maida_rh
maida_rh
SSC Rookie
SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)

Group: General Forum Members
Points: 46 Visits: 111
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:

[url=http://blogs.msdn.com/b/psssql/archive/2009/02/19/how-to-copy-dts-2000-packages-between-servers-and-from-sql-2000-to-sql-2005-and-sql-2008.aspx][/url]

I also need to update 2008 r2 database with sql server 2000 database is i possible ?any pros and cons due to that?
sgmunson
sgmunson
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2853 Visits: 3765
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:

[url=http://blogs.msdn.com/b/psssql/archive/2009/02/19/how-to-copy-dts-2000-packages-between-servers-and-from-sql-2000-to-sql-2005-and-sql-2008.aspx][/url]

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)
Smile Smile Smile
Health & Nutrition
maida_rh
maida_rh
SSC Rookie
SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)

Group: General Forum Members
Points: 46 Visits: 111
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 ?
sgmunson
sgmunson
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2853 Visits: 3765
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)
Smile Smile Smile
Health & Nutrition
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search