MS DTS - Different data types between source data and destination table
Posted on 2006-04-23
I am trying to use MS DTS to import data from a text file into a table residing on a database, but I've noticed that the data in the first column from the text file being imported, has a numeric data type contains numbers and letters, but the data type of the field in the table that data is being imported to, is Numeric (28,0) [Customer_ID field]. And if I attempt to Alter the table to change the Data type to Varchar, I get an error message indicating that this ALTER STATEMENT would violate the established PKY Key contstraints.
I would greatly appreciate suggentions that would faciliate in the mapping or transferring of this column data to the appropriate column within the SQL Server 2000 Database.