DTS Package does work after copying -
11-03-2005
, 02:28 PM
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 |