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 |
|
lamujerdetuhermano10
Yak Posting Veteran
75 Posts |
 Posted - 2008-08-11 : 18:54:00
|
| SSIS outputs a table to a TXT file. But when I recreate the table with a new colunm in the middle (not in the end). SSIS is not producing the TXT file with the new column in the middle but in the end. Any way to fix this. I have to remap all the columns in the Flat File Destination in order to have the new column output in the middle. Is there any good way to control the ouput of the columns? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-12 : 00:25:33
|
| The metadata info of SSIS cant be refreshed dynamically. you need to redefine your transformations everytime metadata changes. |
 |
|
|
lamujerdetuhermano10
Yak Posting Veteran
75 Posts |
Posted - 2008-08-12 : 19:56:49
|
| I found the way. Just go to advanced in the flat file connection. |
|
|
|
|
|
|
SSIS control columns