Pedro,

You can do this using DTS. Established a connection to the DB2/400 using ODBC or OLE DB and setup the transformation from char to date (or if it's easier, do it in two steps ... bring it over in char form and then use a convert SQL transformation to convert it into a date). If it's not a valid date, you will have some issues that you will need to decide how to treat these.

Christine


-----Original Message-----
From: Pedro Zambrano Bojorquez [mailto:mssqldba-ezmlmshield-x76594356.[Email address protected]
Sent: Tuesday, May 30, 2006 1:29 PM
To: LazyDBA Discussion
Subject: migrating data from db2 as400 to sql server 2000

I need to mígrate some tables located in db2/400 to sql server 2000, but db2
not use fields date, use character to store a date, example:"200060430" in
db2, have idea how can I do this? I'ts possible to use dts services to
change this fields character to date format?





Regards

Pedro Zambrano Bojorquez





---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




MS Sql Server LazyDBA home page