I have a DTS package that I copied from to another server because of lack of
space. The package reads a text file and does some transformations/mapping
to columns with a table. When I change the origin of the flat file I get the
following message: The following tasks reference the connection that you
just modifed. Please select the task for which the transformation should be
deleted.

DTS Task_DTSDATAPumpTask_3

If I select this package I loose all of the mappings. Why is this message
appearing? I'm only change the origin of the flat file to be on the local
drive. I'm not trying to change the package at all. I'm just trying to run
it on the a machine with more space and CPU power.

When I choose to clear the transfomation I then try to re-create the map
selecting a type of "Copy Column" I get the following message: A
DTSTransformCopy must specify no Columns (signifying sequential 1-to-1
mapping of all columns) or the same number of source and destniation columns.

In the above case I've selected multiple columns when this happens. I then
go into the properties to map the columns.

What happing here.

Thanks

Because you changed the connection DTS is trying to be helpful and ask
you if you want to modify the tasks that use that connection. I just
say "no".


As for when you are creating a new mapping from scratch.

When do you get this message? What are the steps leading to this?


Allan



"Larry Bird" <LarryBird (AT) discussions (DOT) microsoft.com> wrote

answer?

From http://www.google.com/search?hl=en&q...=Google+Search

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com