just a small help for you...

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:5773459616034

Why don't you wanna use update cascade?

another work around is..

drop the foreign key relation ship update values in both the tables and again create the foreign key relationship between tables.

🙂

use SQL task and use update statement to update your table inside SSIS package.

hope this will work..

Hi..

Try this.. SaveAs dts package as structured file system and then migrate it to SSIS.

Use script task and extract the date of creation property of the file, with the help of that you can extract 12 recent files from the folder.

Hi Sonia..you can also check the size of your tempDB that may also cause you a problem and along with that check the table lock also.