RE: SSIS truncates and/or rounds the data

Hello,

I tested the issue on my side but I didn't reproduce the issue. Can you
post here the detail steps to reproduce the issue?

For your reference, I tested the issue by performing the following steps:

1. Create a excel file which include the following data:

col data
1 1234.123456789010

The data type of the data column is Number which decimal places is 12.

2. Use SQL server Import and Export wizard to import data from the Excel
file into a SQL server database.

3. Choose the excel file as data source file. Check the "First row has
column names"

4. Choose the SQL server database as the Destination.

5. Select the "Copy data from one or more tables or views" option.

6. On the "Select Source Tables and Views" screen, check 'Sheet1$', click
the Edit button.

On the "Column Mappings" window, map the data column as float data type or
nvarchar(200) data type. The SQL statement looks like the following:

CREATE TABLE [test5].[dbo].[Sheet1] (
[col] float,
[data] nvarchar(200)
)

7. Follow the wizard to finish it. Execute the package.

It works fine on my side and the data is imported successfully. I hope the
information is helpful.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.







.