December 17, 2012 at 3:28 am
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 🙁 any suggestion to resolve it ?????
December 17, 2012 at 7:41 am
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)
December 17, 2012 at 9:09 pm
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 🙂 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
December 17, 2012 at 9:47 pm
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) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
December 17, 2012 at 10:38 pm
December 17, 2012 at 10:46 pm
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)
December 17, 2012 at 10:58 pm
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 ?
December 18, 2012 at 5:07 pm
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)
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply