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 |
|
sharc
Starting Member
8 Posts |
 Posted - 2007-07-19 : 14:18:41
|
| 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? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-19 : 15:29:01
|
| Does the file you are looking for have those new columns? Did you preview the file to confirm? |
 |
|
|
sharc
Starting Member
8 Posts |
Posted - 2007-07-19 : 15:50:31
|
| Yes, the text file shows those columns, but the preview doesn't. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-19 : 15:57:33
|
| The file uses same column delimiter for new columns? |
|
|
|
sharc
Starting Member
8 Posts |
Posted - 2007-07-20 : 07:39:32
|
| fixed .. . .I uninstalled and reinstalled sql .. .. go figure :p thanks for your help though! |
|
|
|
|
|
|
|
|
help on source columns