I tried editing the XML FIle in notepad & replacing the GUID with a valid one but I got an error that the connect was not valid.

I had to delete...

I was still getting the same error. The only thing that changed was the number...

I changed the connect for each execute SQL Task associated with each Event Handler and I'm still getting 43 errors.

How can I isolate the source of the problem?

Perhaps I could...

I found that the problem was in the Event Handler for each task.

I had copied the task form another package. I changed the connection on each task as is required...

The script did not attempt to add the same table twice.

I closed evertyhing down & logged back in and everything appreas to be normal again.

Very wierd.

Thanks.

Comments on the following article?

http://agilebi.com/jwelch/2008/09/05/error-redirection-with-the-ole-db-destination/

Matt Miller (#4) (7/27/2012)

---

That was kind of the point of my previous comment. If...

I would bet that the problem is as you have been advised and you are already aware that the SQL Server Service is not running as a Domain Account.

Can you...

I set the variables used by the Derived Column String and I had them mapped to VARCHAR Data Types.

I get the error:

Cannot convert between unicode and non-unicode string data types

When...

I think that I found what I need.

http://www.mssqltips.com/sqlservertutorial/211/sql-server-integration-services-ssis-data-flow

I appreciate all of the feedback.

I modified the code to return the Error Information as a Parameter and I perform the Inserts in the CATCH Block of the calling Stored Procedure.

The calling SP Inserts records...

I do not see an option to redirect errors from an Execute SQL Task?

opc.three (7/26/2012)

---

Welsh Corgi (7/26/2012)

---

Thanks for all of the ideas.

I got audited today but an outside firm and I got dinged for having the Staging and Data Warehouse on the same...

Thanks for all of the ideas.

I got audited today but an outside firm and I got dinged for having the Staging and Data Warehouse on the same server. :blush: