Good mornig,
I want my table column to accept redudant data type, so what to do?
Regards
What do you mean by that ?
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
every day i got information from my client, like an xls file (MS EXCEL sheet), when trying to import this data on the database that i have created using SSIS, i got an message,.... the data that i want to import content redudant data. then i want to know what to do in order to import data from an .xls file, event this file content redudant data ( same data in differents field of a culomn) using SSIS or other methode.
my english is not correct but i do my best.
please help me.
Best regards.
|||Are you getting an error ? if yes, what is it ?HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||
It's most likely that the fields in your table that you want to contain redundent data actually have a unique constraint on them so that they don't accept redundent data. This happens automatically if the field is a Primary Key.
If the problem field is not the Primary Key, then you may be OK removing the constraint, if it is the Primary Key, then it must be unique beause it's is being used to uniquely identify the record. In this case you would need to either find a different Primary Key (which must be unique) or put your redundent data in a differnt field.
If you data is very redundent, then you may need to consider normalizing it by putting it into multiple tables to eliminate redundent entries. SSIS can do this as part of the transformation step. You can find information about what database normalization is and how to do it. Consider starting here to learn more.
Regards,
Mike Wachal
SQL Express team
-
Mark the best posts as Answers!
No comments:
Post a Comment