Results 1 to 2 of 2

Thread: SSIS Package - Need to Check Update/Insert

  1. #1
    Join Date
    Apr 2009
    Posts
    20

    SSIS Package - Need to Check Update/Insert

    Dear all,

    I have flat file which i am going to upload in db. The new records only should be imported from the flat file. How is it possible in SSIS package?. Please responds it.

    Regards,
    M.S.Srikanth

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    You can load data to staging table then move non-existing rows to target table with t-sql, much easier.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •