Transform Data Task

Question

Transform Data Task

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

kevina Grasshopper Points: 17 More actions · Answer 1

Try this problem with a simple fixed length format file of let say two cols then add a thrid col to the middle of the file you'll see that when you open the text file source you will have to fix the fixed length properties to cater for the new col. when you click ok it will ask if you want to delete your transofrms say no. open the data pump and gol to the transforms tab and you should be able to edit and move your transforms around.

deek SSCommitted Points: 1886 More actions · Answer 2

well the only way i'm up for doing this readjustment is if i can get SQL to automatically re-route the references of every column to the right of the insert, in this case, approximately 400 columns.

if there's a way to do this, i'd like to learn it, considering that i will need to add new columns to this text file regularly; and to re-reference 400+ columns, as well as re-write the associated VB code every single time i make a minor adjustment, would be incalculably tedious.

any other suggestions?

philcart SSC-Forever Points: 47797 More actions · Answer 3

Do you get any sort of format file or header record that can be used to determine the columns?

If so, and you're using SQL2K, have a look at the properties of the Text file connection and the DataPump task. You might be able to manipulate/rebuild the column list based on the formatting info.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

--------------------
Colt 45 - the original point and click interface

kevina Grasshopper Points: 17 More actions · Answer 4

from what i've seen you going to have re-reference some of the old cols but you won't have re-write any of the code only edit which which cols they point too.