Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
afarrington
Starting Member
1 Post |
 Posted - 2005-08-25 : 17:48:54
|
| I modified a Sql 7 DTS package that contains Connection 1: a MS SQL Server database, a transformation arrow(containing the sql query) and Connection 2: a text file output.I modified the sql query, removing/adding columns in the select statement. When I saved it, it told me it needed to delete/modify the transformation. It seemed to handle that part okay. However, when I right clicked on Connection 2, choose properties, then attempted to close by clicking OK, the Task References message window appeared with the comment that "The following tasks reference the connection that you just modified. Please select the task for which the transformations should be deleted." In the task name box,DTSTask_DTSDataPumpTask_1 appears. I went back to the transformation area and saw that a new source column was not listed in the destination, and a column removed from source was still in destination. I corrected these items however still got the same error message. I then responded to the Task References message, and checked clear transformations for DTSTask_DTSDataPumpTask_1 . I still get the same message.Any idea what I am supposed to do here?Thank you! |
|
|
thebruins
Starting Member
31 Posts |
Posted - 2005-08-26 : 06:21:09
|
| "I then responded to the Task References message, and checked clear transformations for DTSTask_DTSDataPumpTask_1 . I still get the same message."how about this: make sure Connection 1 and 2 are all setup, so you don't need to modify them any more. Also, just 'cancel' your way out of 'Task References' if you can.Next, fix the transfer arrow by setting a source query, populating the destination columns from the source, and doing some mapping between source & destination columns... . Just do all tabs from left to right, and all should be ok |
 |
|
|
|
|
|
|
|
DTS package: Task References