We recently upgraded our SQL 2000 Servers to SP3a. We can no longer edit the
transformations on several of our DTS packages. This problem occurs on all
of our packages that export data from SQL. Some export to text files others
export to an AS400. The error is:
Some of your transformations refer to columns that do not exist in your
source or destination.
At this point I have the optoin to Remove invalid transformations, Change
source/destination or Remove all transformations and redo automapping. Some
of these trasformation include script that I don't want to have to redo. I
have reinstalled SQL on my laptop without installing SP3 and I can use that
to edit these transformations.
Can anyone tell me if this is a known issue or if there is a solution?

Column level permissions?

Ilya

"LZBMikeO" <LZBMikeO (AT) discussions (DOT) microsoft.com> wrote

No, we don't use column level permissions. Thanks.

"Ilya Margolin" wrote:

I have never seen this before but

1. The error suggests the transformations are invalid in that the columns
no longer exist in some/all of the transformations
2. Check you are pointing to the correct servers
3. From where are you retrieving the package (SQL Server, Met Data
Services, File)


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"LZBMikeO" <LZBMikeO (AT) discussions (DOT) microsoft.com> wrote