SSIS Flat File Destination Export data issue

2019-08-10 14:23发布

Am exporting data from a SQL procedure to flat file. My issue is i have a column called Test with data 1e2, 1e1, 1e3 ..... .When i export to flat file, data for this column looks like 1.00E+02,1.00E+01,1.00E+03...... . What should i do to get exact data into flat file from SQL proc. Any help is appreciated.Thanks.

2条回答
甜甜的少女心
2楼-- · 2019-08-10 14:44

This solved my issue,

Created a excel template with Test Column as text.

In SSIS, Created OLEDB Source, Data Conversion and Excel Destination tasks. In Data Conversion i converted Test Column to Unicode String DT_WSTR. I executed the package and it populated data into the template i created with 1e1,1e2...in Test column.

查看更多
霸刀☆藐视天下
3楼-- · 2019-08-10 14:45

Make sure the column in your Flat File Connection Manager has DataType of string [DT_STR]. This will avoid the implicit conversion done on your column by SSIS. See the image below:

Setting flat file connection manager

查看更多
登录 后发表回答