AndrewZX
Technical User
- Oct 22, 2013
- 2
I've done basic table loads with SSIS and had success but now have a complicated report to load.
The format is similar to this:
The problem is to impute or fill in fields missing from the report, to fill in all fields
during the ETL. This would be a simple programming task in Perl or Python, but how
do you approach this in SSIS?
Any pointers or recommendations greatly appreciated!
The format is similar to this:
Code:
TransactionID UserID firstname lastname itemID itemdescription itemcost
100001 1001 Joe Jones abc black shoes $50.
100002 1002 Jane Johnson bcd red shoes $60.
cde green shoes $61.
def blue shoes $60.
100003 1003 Jay Jackson efg orange shoes $50.
The problem is to impute or fill in fields missing from the report, to fill in all fields
during the ETL. This would be a simple programming task in Perl or Python, but how
do you approach this in SSIS?
Any pointers or recommendations greatly appreciated!