data mapping and migration

Has anyone used DTS packages for migrating old data to a new schema?

If so are there any tutorials on this?

I'd prefer not to do this by hand. ;-)Just use DTS graphic wizard.
BOL is the best tutorial|||Try the wizard in Enterprise Manager. That's a nice easy intro into it.|||I have a simple package where I want to dump data from one table to another. Its erroring out on this line.

DTSDestination("TaxExempt") =1

The destination field is int.

I don't receive any errors when i have the following:

DTSDestination("ShippingWeight") = DTSSource("weight")

for some reason it doesnt like the hardcoded value i supplied it.

Any ideas why?

Thanks for the help.

Data from versant into MS SQL

Hi all,

I'm testing some software based on versant database
(only on an application level) with Winrunner.

On the other hand I'm a business intelligence consultant and doing a lot of datawarehousing and cube building.

Now I'm curious if there is a simple way of getting data
from the versant database into MS SQL databases to
use the data for reporting/olap purpose.

Do you know any connection possibilities, ODBC drivers or
connection string examples to
a) get metadata from versant
b) get data from versant.

thanks in advance

MichaelGoogle (http://www.google.com/search?hl=en&q=versant+odbc) is your friend!

-PatP