Results 1 to 2 of 2

Thread: SSIS Package - Need to Check Update/Insert

  1. 04-07-2009, 04:48 AM #1
    srikanth.mss
    srikanth.mss is offline Registered User
    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
    Reply With Quote Reply With Quote
  2. 04-07-2009, 08:10 AM #2
    rmiao
    rmiao is offline Registered User
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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
  •  

Forum Rules