When moving data between systems.
I strongly encourage you to..

1. Dump the data in raw-text (char) only types
2. Load the data in raw-text (char) data types into staging tables in the target system
3. Convert to proper data types from staging to target tables

Why?
1. allows the source to be verified as actual source data.
2. allows for "GIGO" garbage in - garbage out.
3. allows for easier troubleshooting on type-conversion errors.

And lastly.... DTS Sucks ! BCP Rules !

Dano Smith



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

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