Dear all

I'm using SQL Server 7 + SP4.

When i edit a DTS and want to save it , "Invalid transformations detected.
Verify and retry your transformations." occurs.

anyone overcome this problem ??

thanks

redo your mapping
You have changes something in the source or the destination and the mapping
is off


“I sense many useless updates in you... Useless updates lead to
defragmentation... Defragmentation leads to downtime...Downtime leads to
suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG and
DBCC DBREINDEX are the force...May the force be with you" --
http://sqlservercode.blogspot.com/



"jeff" wrote:

Basically the source and the destination mappings no longer look like
they did when you created the package. DTS has looked at the source
columns and the destination columns and cannot create the mappings. You
will be resented with 3 options when this occurs and once of those is to
redo the auto mappings. Before doing that though you may want to find
out why the definitions have changed.

Allan