DTS PROBLEM!!! HELP

Last Post 25 Apr 2002 10:50 AM by LACBA_SQL. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
LACBA_SQL
New Member
New Member

--
25 Apr 2002 10:50 AM
I'm importing data into a new table, to later export to the target database.
the source data has a field ADDRESS_CODE that has a value of PRIM (VARCHAR) data type, for primary addresses, How can I convert (PRIM) to be 1 and the new field called "AddressID" to be INT data type in the new table?


Acceptable Use Policy
---