[font="Verdana"]Thanks Greg for your suggestions.

Here I would like to know one thing. While setting DTS package properties, I had enabled Use Transactions option in DTS package properties - Advanced...

[font="Verdana"]

Thanks Greg for you reply. Yes, you understood right. I want my DTS package to send an email and stop its execution if any task fails. But I didn't get...

[font="Verdana"]It won't be possible to insert record(s) in either the tables. Let us know the exact situation.

Mahesh[/font]

[font="Verdana"]Thanks for updating me. I have wrongly mentioned SP4. Its actually of Windows.

Mahesh[/font]

[font="Verdana"]Thanks Erik for your help. I tried the way suggested in the mentioned blog. However still I am unable to Debug my SSIS package. Even I tried the same thing...

[font="Verdana"]Thanks Erik for your help. I tried the way suggested in the mentioned blog. However still I am unable to Debug my SSIS package. Even I tried the same thing...

[font="Verdana"]I don't know whether it is logical, and even I didn't tried such thing yet, can you write delete statement inside the trigger for deleting the records from table on...

[font="Verdana"]Why don't you use SQL Server Integration Services - SSIS where you can Import/Export Tables from one DB to another.

Let us know on this.

Mahesh[/font]

[font="Verdana"]Thanks Lowell. Things get clear to me now.

Mahehs[/font]

[font="Verdana"]There is a bit confusion between the requirement and table definitions given by you. There is not any relationship between the tables you have specified. Please post with atleast exact...

[font="Verdana"]To do this you need to use Dynamic SQL inside the SProc.

Mahesh[/font]

[font="Verdana"]

I didn't...

[font="Verdana"]why don't you go for OLE DB data provider which is alway recommended.

Mahesh[/font]

[font="Verdana"]

Can you please come with more details so that we can understand the issue in full. Why there is need to disable and re-enable the constraints every time?

I think you...

[font="Verdana"]It seems that you are trying to delete duplicate records. What you have to do is to write a query in SQL Server 2K to return the duplicate records using...