"Join Transaction If Present" Workflow Option Causes Package to Fail

[Joeybear23]

We recently updated to SP4 on all of our servers, and overall it was a success. However, one server in particular began having some failures in a DTS package.

We have always had "Join Transaction If Present" set to 1 (check in box) on this package so that we could use rollback in the even of a failure.

The problem now is that the package will fail with this error unless we set it to 0:

Error:  -2147220472 (80040408); Provider Error:  0 (0)      Error string:  The Data Pump Task requires Transformations to be specified.      Error source:  Microsoft Data Transformation Services (DTS) Package

Any ideas?

SQL/SAP DBA

 

[Catadmin]

Might want to head out to MS's website and see what SP4 "fixed" that might affect this for you.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[Joeybear23]

Microsoft Support is stumped on this one now, and has been for a week...

SQL/SAP DBA

 

[Joeybear23]

Well, I figured it out:

I had to uninstall and reinstalll msdtc as per

http://support.microsoft.com/default.aspx?scid=kb;en-us;279786

SQL/SAP DBA