SSIS Export Access Table To File - Incorrect Data Type

Question

I'm exporting an MSAccess table to a flat file using a simple Data Flow Task in VStudio SSIS. My problem is a column, defined in the table as Number(Double) is being forced to scientific notation, no matter what data type I select in the destination flat file connection manager.

Is there someplace else to determine the source data type?

I have a source connection manager where I defined the MSAccess file connection and the table to use. Then I have a destination flat file connection, which is where I have the ability to select data types and do the mappings.

Answer 1

In the destination connection manager, try the float data type(if you haven't already).

Answer 2

Open the Data Flow Task source in "Advanced Editor".

Go to "Input/Output Properties".

Select "Source Output/Output Columns".

Change the data type of the column to DT_STR.