I’m looking for advice for the following scenario:
Import Source:Flat File – 2 columns (student#, lunch_bal)
Destination:SQL Table:
Trnpayuniq (PK)
Atype (all values = ‘S’)
Auniq ( from flat file – student#)
Trnamt (from flat file – lunch_bal)
Trnpayc (all values = 1)
I’ll truncate the destination table before each import.
Is the best way to create a temp table; get it populated
then update the destination table?Or
would the use of Merger (Merge Join) be the better approach.
Thanks for any direction.
Could you just added a Derived Column transform to add the constant values to your data flow?|||I'll try that. Thanks.|||If it works, please mark the question as answered, per Phil's sticky post
