
December 13th, 2004, 01:41 PM
|
|
Contributing User
|
|
Join Date: Jun 2004
Posts: 33
Time spent in forums: 1 Day 3 h 41 m 24 sec
Reputation Power: 5
|
|
|
Updating a DTS
Hello,
I have a few DTS that are running against views on our DB and dumping the results into a flat text file. Now these views have changed recently, but the DTS has not been taking the new fields. It's like it didn't recognize the change.
When I open the DTS in design view, and choose preview, it shows all the data but then says something like:
Some of your transfermations refer to columns that do not exist in your source or destination.
Remove invalid transfermations
Change source/destination
Remove all transformations and redo auto-mapping
And being a text file, there really are not columns to map to. It doesn't see, to let me use any of those options effectively.
Any ideas?
|