I am currently trying to setup Transformation on a Transactional Publication. When I finish setting up all the transformation info for the package and click finish to save the DTS package I get the Message "SQL Server Enterprise manager could not complete this operation." this message comes up when it is in the "Adding task 1 of 1" phase in the Creating the DTS package for replication wizard.
Thanks