SQL Server Performance

to create a SQL DTS package

Discussion in 'SQL Server DTS-Related Questions' started by tfakih, Jul 7, 2006.

  1. tfakih New Member

    I want to create a SQL DTS package to perform the following:

    - Users upload excel files periodically to server with the same column
    - Once an excel file has been uploaded, need to read and validate the data
    (combination of User_ID & Group_ID should be unique)
    - then import data rom Excel to existing database,
    inserting data if record is not present and
    updating data if present
    - errors need to be logged to database and emailed to user

    How can I achive this task...I m new to DTS...Pls guide me.

    Thanks in advance.
  2. Adriaan New Member

  3. dineshasanka Moderator



Share This Page