Maybe reading the SqlServer DTS manuals would help?
Wouldn't you have a similar problem if your data source was Oracle?
Perhaps this is a question for Sqlserver forums moreso than informix?



-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org] On Behalf Of Rodolfo
Sent: Tuesday, October 31, 2006 5:58 PM
To: informix-list@iiug.org
Subject: How to map data

Hi everybody!

I'm working on a migration from Informix to SQL Server... I'm doing it
through DTS and ODBC.

What I'm doing is using the DTS, my data origin is tha Informix
database and mi target is the SQL Server database that I just created,
this is via IBM Informix ODBC and I copy the tables... but the results
are something like this:

--INFORMIX--


create table r_cap_dbt_uni
(
num_db smallint ,
cve_uni char (8) ,
fecha_mens datetime YEAR to MONTH ,
valor float ,
primary key ( num_db, cve_uni, fecha_mens ) ,
foreign key ( num_db )
references cat_db_tec ( num_db )
);


-- SQL SERVER --


create table r_cap_dbt_uni
(
num_db smallint ,
cve_uni char (8) ,
***********************************************
fecha_mens smalldatetime ,
valor float ,
***********************************************
primary key ( num_db, cve_uni, fecha_mens ) ,
foreign key ( num_db )
references cat_db_tec ( num_db )
);


as you can see the float and datetime year to month data types change
like the example before.... I changed the "float" datatype manually to
"decimal" datatype... but I don't know what to do with the "datetime
year to month" Informix datatype, I mean, I dn't know why the DTS
changes this datatype to "smalldatetime"... how can I map this? what's
the process?


Thank you very much!


Rodolfo

_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
================================================== ==========
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
================================================== ==========