July 19, 2007 at 12:47 pm
I've got a text file that is being sent to the server every day, and they've recently added new columns into the file, to put into new fields created in the table. So I need to update the dts package.
So I've gone into the Transform Data Task Properties, and the source is set to the text file, the destination has all the new fields in there that was automatically updated based on the new fields created in the table, but on the Transformations tab, the source column does not list the new fields under the "Source" table (the "Destination" table looks fine though with the new columns).
I just can't figure out how to add these new fields to the source! I've gone into the edit portion, and into the "Source Columns" tab, and once more under the "Available columns" table, the fields aren't listed there (nor are they listed in the "Selected columns").
Please please please, can someone help me with this? I'm sure it's some simple setting, but for the life of me can't figure it out. Can anyone please help?
July 19, 2007 at 1:52 pm
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply