There is a problem with my DTS package that read a text file and
migrate the data into a SQL table. Every time when I reopen the package
and try to modify the transformation link between the source and the
destination the following error appears:
"Some of your transformations refer to columns that do not exist in
your source or destination."

I'm sure that my source and destination are all valid since if I
execute the package, it'll completed successfully. But for some unknown
reason, it just couldn't display anything when I clicked on the
transformation tab. This doesn't happen only to a single package. Some
of my colleages have the same problem on thier other packages. Is this
is known bug in SQL 2000? I'm using SQL 2k on Windows XP. Please advise
and thanks for your time.