You just have to remove the FK relationship which is preventing the deletion first:

update fk_test

set fno = null where fno = 5

delete fk_test where eno = 5

select * from fk_test

I wrote the above response before trying Craig's solution, which certainly does the business - thanks! Maybe this is one instance where a loop is the best solution. I'll leave...

First of all, thanks to everyone who has taken the time to think about this problem and contribute. I spent over an hour blowing recursion limits left, right and centre...

Correct.

rhythm.varshney (11/27/2012)

---

Phil Parkin (11/27/2012)

---

There is no good way of doing this in SSIS - I'm with Jeff on this one.

If you want to put an SSIS 'wrapper' round it, something...

There is no good way of doing this in SSIS - I'm with Jeff on this one.

If you want to put an SSIS 'wrapper' round it, something like this would...

You still have not asked a single question - there is nothing to respond to.

Have you tried {CR}{LF}?

In your Flat File connection manager, what is the value of the Row Delimiter property?

rhythm.varshney (11/25/2012)

---

Phil Parkin (11/25/2012)

---

rhythm.varshney (11/25/2012)

---

I need to import the data into the table.The logic is If Type is MSAD then it should update MSAD...

rhythm.varshney (11/25/2012)

---

I need to import the data into the table.The logic is If Type is MSAD then it should update MSAD column of table...

grantbanjo (11/23/2012)

---

Hello,

I am using SSIS in SQL Server 2008 R2 and have been creating packages for a few years, but have not done so where the packages will be going...

Could it be that the server's default date format is dd/mm/yyyy and your PC it is mm/dd/yyyy (or vice versa)?

So what is your question?

What is the data type of User::SCH_DFEE?