0

I want to update data content of table A with data content of CSV file,(table A and CSV file have the same column name).

Is merge join my best option?

enter image description here

BIDeveloper
  • 2,628
  • 4
  • 36
  • 51
BKChedlia
  • 327
  • 2
  • 4
  • 18

1 Answers1

1

I prefer to use staging tables:

  1. Import csv file to staging table via flat file source
  2. Create a Sql Task that updates tableA from staging table and truncates/deletes staging table in the same transaction
Community
  • 1
  • 1
vercelli
  • 4,717
  • 2
  • 13
  • 15
  • @BKChedlia - on the control flow tab connect your Data Flow task with an Execute SQL Task. In that Execute SQL Task place the `update tableA set field1=t.field1, .... from stagingTable t where tableA.id = t.id` and your delete or truncate in the same transaction – vercelli Jul 05 '16 at 09:18
  • @BKChedlia How did it go? – vercelli Jul 26 '16 at 11:52