Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2010
    Posts
    153

    Smile Unanswered: migrating same data twice should be restricted

    Hi guys,
    yet another problem for me . I am migrating data dynamically using SSIS. i don't want to insert same data twice. I have a table names as Student.

    columns are

    firstname lastname cust_id
    --------- ----------- ------------
    sunny sng aoo1
    satru huthut b001
    abcdef sadcascas c001

    suppose sunny already exists in database i dnt wanna insert same values again and while migrating i wanna check. can any1 write a procedure or trigger for me since iam new to database



    thanks

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    Try to use a primary / unique key and let SQL Server do the rest.
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

Posting Permissions

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