Hi Michael,
as far as i know there isn't a stand-alone task that can entirely
fulfill your needs (ie, normalization).
Therefore, you can perform a normalization combining more tasks. But
how to do it, well this depends on your architecture.
Is this task going to be scheduled? Or are you going to execute it una
tantum? how many 2b-normalized-tables and how many attributes (eg,
type) must be decoded that is how many tables do you have to create in
order to normalize the db? Are they going to be alwalys the same
number?
Quote:
If someone could provide a little assitance of any kind I would be greatly
appreciative as my current project requires a ton of this. |
For future questions about SSIS please take a look at (or post on):
microsoft.public.sqlserver.integrationsvcs
Bye,
M.