Dear fellows,
I know that I think as sql2k programmer-dba yet but I can’t avoid.
I’ve got Flat File Connection Manager Editor dragged with a text file as ‘ragged right’ format and CRLF as header row limiter. When from properties page and Columns option I’m going to alter just a few colums I am not be able.
It seems that you must erase all of them in order to define one or two. And in the case you’d have 50
When I ran sql2k DTS designer did that without problems, alter columns again and again.
As far as I know it’s a lose of flexibility, or not Or is there any way for do that without deleting nothing else
Redefining columns isn't possible with Flat File Connection Manager Editor properties already fixed??
Tamer Ismael
Once you move from the Columns tab to the Advanced tab you can only edit columns in the Advanced tab. This is simply because when you delete or add a columns, it is impossible for us to know automatically how you want to adjust the adjacent columns to compensate.
It is true that if you want to go back to the Columns tab to make adjustments, then you do need to reset all columns.
In the Advanced tab you can delete columns, and insert new ones before and after the currently selected column - is that not flexible enough You certainly do not need to delete them all.
Donald
c0nfig