All geek questions in one place

SSIS Flat File Destination Data Export

I am exporting data from an SQL procedure to a flat file. My problem I have a Test column with data 1e2, 1e1, 1e3 ...... When I export to a flat file, the data for this column looks like 1.00E+02,1.00E+01,1.00E+03...... . What should I do to get the exact data in a flat file from SQL proc. Any help is appreciated. Thank.

+1
source share
2 answers

Make sure the column in Flat File Connection Managerhas DataTypea string [DT_STR]. This avoids the implicit conversion done in your column using SSIS. See image below:

Configuring Flat File Connection Manager

+1
source

This solved my problem,

Created an Excel template with a test column as text.

SSIS OLEDB Source, Data Conversion Excel Destination. Unicode DT_WSTR. , 1e1,1e2... Test.

+1

Source: https://habr.com/ru/post/1689775/

More articles:


All Articles