I have a column in a 2000 SQL Server Database that is of the text data type. I would like to restrict the possible values to either 'blue', 'red', or 'green'. Any help is appreciated, and I will reward points quickly.
Or you can do it using Enterprise Manager - right click on table -> design table
in the table designer, right-click and select Check Constraints
there you acn enter the constraint name e.g. CK_mytable,
SQL Server Integration Services can read XML files, that’s known by every BI developer. (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.)
But how far can you go? When does the XML Source component become …