dbTalk Databases Forums  

DTS Package does work after copying

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS Package does work after copying in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Larry Bird
 
Posts: n/a

Default 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



Reply With Quote
  #2  
Old   
urchin
 
Posts: n/a

Default Re: DTS Package does work after copying - 11-04-2005 , 07:38 AM






Might try modifying the value using the Disconnected Edit (shouldn't do
whatever check it's doing that's causing your prompt)


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.