Hi Vítor

      I face the same issue in DTS. Could  u pls give me any solution for this below problem?

Source are 10 files

Desintation are 10 tables .

can we map...

Hi urvashi

    Thanks a lot . let me try out this approach .

Thanks

Jones

Hi urvashi 

sorry for the confusion

I have following tables. need to import from source to Destination using DTS

Source   Destination

Emp    ----- EmpInfo    (emp and ...

Hi Darrell

      Thanks a lot. i  am using Data Driven Query which takes care of update and delete.so no need to write sps

let me try with VB Com.

Thank you

Hi Darrell

      Thanks a lot. i  am using Data Driven Query which takes care of update and delete.so no need to write sps

let me try with VB Com.

Thank you

Hi Diane

        Thanks a lot .its  a good idea to implement in my package.

Regards

jones

Hi Rookie

       Thank You for the suggestions.But i thought there might be some other solutions.

 I Feel this makes little over head . The purpose of Creating user defined...

Hi Goce and Phil

     Thank you  , Now i ve understood the Procedure to handle this situation .

I really happy to get cleared these doubts

Regards

Jones

Hi Goce

          Thanks for the reply , but  im still   not clear. I want to avoid the recreation or altering of sps again. 

pls answer this query if any one faces this...

Hi Robert

 Happy to get help from u . I thank u  for the information . I ll do steps given by u .

Thanks

Jones

Hi Steve

       Thanks for the help . but all tables dont ve the date fields in my database . I ll try with ur other solutions

ThanQ

Cheers - Jones

Hi CipWiz

 I m happy to get  reply from u.

I Thank you for  ur valuable guidance

Jones