We are developing a process to import data from a CSV file that we are designing. ÃÂ Although right now our CSV file has 23 columns, over time we will gradually be adding more columns (roughly 1 to 2 more columns per month). ÃÂ Although the process has worked great I have run into a snag. ÃÂ When we initially set up the connection manager we went in to the "Advanced" section to specifically set theÃÂ outputcolumnwidth
ÃÂ field sizes (they all defaulted to 50). ÃÂ The problem is that whenever we modify this connection manager to accept the new columns that we add to the CSV file it resets all of theÃÂ outputcolumnwidth
values to 50 no matter how we try it. ÃÂ Is there some way to make them keep the values that we set?
For example, our first field is "ID" and we initially changed it from "50" (the default) to "15". ÃÂ The next month when we added two new columns, the "15" got changed back to "50" and we had to set it again. ÃÂ This happens for all of the already-specified fields.