SQL Server Performance

dts

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

  1. sonijaiswal New Member

    Hi/Satya/all here is my simple question regarding DTS. Thank You you have been helping me, My problem now is I want to import the data from a pipe delimited file., here the situation is the pipe delimited file could be a notepad file or an excel sheet. Now my doubt is before importing the table.Can I check the condition whether the composite key of the incoming table and the destination table matches.If it doesn't matches then the file has to be rejected. how should I do it. If I do it by using a staging table then also before importig I have to give the condition to import. can you plese please give me some idea i am really stuck with this problem I didnt face this problem in my previous projects.So plese help me.
  2. satya Moderator

    You have to control this using ACTIVEX or VB script,as nothing can be done with DTS in this case.

Share This Page