This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 96%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Hi All,
I have SSIS package export from SQL table into CSV file. After export, as shown below some of the data in CSV file is not same as per SQL table. Upon checking the data type in output column EXCESS at advanced editor of source, it is in NUMERIC. Any suitable data type to ensure I got the same in CSV?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
@jn93 ,
Please add to your question what SSIS Tasks are in use to produce a *.csv file.
A screen shot of the Data Flow Task (DFT) will be useful too.
Hi @jn93 ,
You can use a Derived Column Transformation for your goal.
Please try the following expression:
Excess < 1 ? "0" + (DT_WSTR,6)Excess : (DT_WSTR,6)Excess
Thanks @Yitzhak Khabinsky
Hi @jn93 ,
Like YitzhakKhabinsky-0887 said that you may use a Derived Column to change the format of the value.
Thanks @ZoeHui-MSFT ...but is there a way to do it from advanced editor
Temporarily we could not do that via advanced editor