SSIS and Normalizing Data in TXT file
I'm learning SSIS and I have a question about how to normalize existing
data in a text file.
In my directory I have a text file for each state in the United States so
AK.txt and AL.txt has the following structure:
AK,F,1910,Mary,14 AL,F,1910,Mary,875
This stands for state,sex,year,name,frequency
If I have the following tables:
State(id,state)
Sex(id,sex)
Year(id,year)
Name(id,name,frequency)
What transformation in SSIS would I use to put each data element in it's
respective table?
No comments:
Post a Comment