Tuesday, March 27, 2012

Advice on Flat File Import

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

No comments:

Post a Comment