SQLKnowItAll (5/15/2012)

---

I don't think anybody's mad. We want to help and, probably more importantly, learn. We just couldn't do much with the error except for take it at its word....

Lynn Pettis (5/15/2012)

---

Welsh Corgi (5/15/2012)

---

I'm getting the following error:

The MERGE statement attempted to UPDATE or DELETE the same row more than once. This happens when a target row matches ore...

I had to delete the task and recreate and and the problem went away.

My guess is that there was some corruption.

I had to take a time out from that package.

In one of the containers where I'm having this issue I attempted to drag all of the tasks outside the container.

"When...

Thank you Elliot.

I running it for now for I'm trying to get it loaded.

I'm not expected to work today but I would like to keep things moving.

It turned out to be a memory issue.

Saved script to the Server and executed and it completed successfully.

Thanks for your input.

What you suggested is...

It did not paste the entire script which is huge.

ok here it his. It will probably work on your machine.

I ran it yesterday with no problem,

I had to drop all of the objects and recreate today but when I...

Post removed.

I copied the DDL to create the table but when I tried to copy & paste the SQL Statements primarily INSERT Statements it keeps hanging on me.

I have never seen...

At the bottom of the screen there is yellow bar that includes sections for Query Completed with Errors and a warning symbol followed by the Server Name 10.1 SP1 and...

Cool thanks Lowell.

I found it.

GRANT EXECUTE ON SYS.XP_PROP_OLEDB_PROVIDER TO Login;

nhimabindhu (5/8/2012)

---

Hi,

consider the @[System::ContainerStartTime] as a new column in derived column transformation and while mapping into the destination table , map the modified_date column with the derived column which was...