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.
