SQL Server Performance

dts

Discussion in 'SQL Server DTS-Related Questions' started by sonijaiswal, Oct 24, 2007.

  1. sonijaiswal New Member

    here is my situation I have to create a DTS package which
    reads the data from a table and checks whether
    the composite key of the data which I am transferring matches with the
    destination table.Now my doubt is where we check the
    condition for the compositekey match,is it in the transform data task
    or is their any other way.will be thankful if you
    gusy throw some ideas.

  2. martins New Member

    You can do this with a Data Driven Query Task. In my opinion though, it would be better to transfer the data to a staging table (if it is on another box) and then write a stored procedure to do what you require. This would also be much quicker than using the Data Driven Query Task.
    Hope this helps.
  3. satya Moderator

    Do this task with a staging table within the database.
  4. sonijaiswal New Member

    Can you explain more precisely how can I do this by a staging table my condition for validity of the data is that,
    to reflect the table name for ease of use for the user. If the composite key in the incoming table does not match a composite key row in the other
    it is a reject.

Share This Page