Hey Dano I wish you would quit sugar coating things and tell us how your really feel!! Ha ha.



Christopher Bellizzi
SQL DBA/Systems Analyst
240 Fall Street
SFO Main Office
Seneca Falls, NY 13148
315-568-7886


-----Original Message-----
From: Smith Dano [mailto:mssqldba-ezmlmshield-x76743157.[Email address protected]
Sent: Tuesday, May 30, 2006 4:47 PM
To: LazyDBA Discussion
Subject: RE: migrating data from db2 as400 to sql server 2000

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



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


************************************
This e-mail and any files transmitted with it are proprietary and intended solely
for the use of the individual or entity to whom they are addressed. If you have
received this e-mail in error please notify the sender. Please note that any views
or opinions presented in this e-mail are solely those of the author and do not
necessarily represent those of ITT Industries, Inc. The recipient should check
this e-mail and any attachments for the presence of viruses. ITT Industries accepts
no liability for any damage caused by any virus transmitted by this e-mail.
************************************


MS Sql Server LazyDBA home page