Hi
I have created a SSIS package which retrive data from Excel file, perform some calculation and insert data into database.My Excel file formate is 'General',
Its column contain data upto 11 decimal.
When I lookup in ExcelSource ->Edit-->Previe, it shows me value upto 11 decimal, but when I am transfering the data to Derived column component it got truncated to 4 decimal.
I am using decimal datatype int Derived column.
Can any one suggest, what will be the problem.
Thanks!!!
Regards,
Abhishek
Problem : Data got truncatedin reading Excel source
Hot Topic
- How to take a SP like a table
- Secure Social Security number in my DataBase
- saving sp results
- Transaction log keeps growing
- MS SQL Server 2005 64 bit CTP:[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
- Date problem
- Launching and monitoring SSIS packages from a web app
- how to create the database level dimentions?
- Right-Click Table -> Import data GONE??
- rsAccessDenied
SQL Server
- Problem in Installing 64-bit Reporting Services
- The configuration of the AdminConnection\TCP protocol in the SQL instance SQLEXPRESS is not valid
- try to setup membership with ASP.NET configuration
- Formatting labels in chart
- SMO Method Performance
- Doesn't like a particular namespace
- Is this a silly way to use SSIS?
- dimension records exceeds 64000
- Transactions/Client-Side Redirect issue
- Connection failed!
Problem : Data got truncatedin reading Excel source
IceStationZebra
I would be inclined to create a package by using the SQL Server Import and Export Wizard and examine the column types that it uses, as well as any Data Conversion transformations that it adds to the data flow.
-Doug