tags:

views:

293

answers:

1
Q: 

SSIS Export Access Table To File - Incorrect Data Type

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.

A: 

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

w4ik  2009-08-26 14:33:55
I have tried DTR_4 - single precision float (which was applied by default), DTR_8, which is double precision float, and even DT_STR (STRING), with the same result.
Joel  2009-08-26 15:17:38
I wonder if adding IMEX=1 to the Access connection string would help...from the comments here http://www.builderau.com.au/program/sqlserver/soa/How-to-import-an-Excel-file-into-SQL-Server-2005-using-Integration-Services/0,339028455,339285948,00.htmNote that one of the commenters also made a registry change so that the Jet engine would look at more rows of data in determining data type.
w4ik  2009-08-26 15:28:47

related questions

How to turn on FastParse in SSIS (SQL Server Integration Services)
Recommend ONE favorite SSIS component that does SFTP/FTPS
SSIS: Remove Duplicates from Flat File
SSIS read flat file, write to DB or C# app,mutli thread read/write?
SSIS gurus: Links to Great Learning Content requested
Potential Pitfalls of inserting millions of records into SQL Server 2005 from flat file
The best way for a SSIS ftp task to not fail when there are no files to copy
SSIS: How to progmatically direct work flow in dtsx package
SSIS Package Puzzle
Import *variable record length* CSV file using SSIS
Using SSIS to refresh a training database from a production database
What are the options for extracting data out of Hyperion 7.3 with SSIS
SSIS Oracle Parameter Mapping
Integration Services: Multiple-step OLE DB operation generated errors
How to insert a row into a dataset via SSIS
SSIS copy directory from FTP location to a shared network location
SQLServer Native Client Error "Connection Busy With Results From Another Command" in SSIS
How Do I Check Job Status From SSIS Control Flow?
How do I get SQL Server Integration Services to use a different database connection for Package Configuration
Can you start a scheduled Windows task from SQL Server Integration Services ?
SSIS: Adding a constant column value when doing a CSV to SQL conversion
SSIS convert image blob
Good Starting Places for SQL Server Alerts/Notifications?
Accessing Excel data source running SSIS package on 64 bit server
Execute stored procedure (SQL 2005) and place results into a CSV file on a FTP location