Solved

CSV file import, Scientific format

Posted on 2016-08-31
4
96 Views
Last Modified: 2016-09-15
Hello

I have a few csv files that has the following values in a scientific format:

ACCOUNT_NUMBER, INVOICE_NUMBER
1E+11, 2.0225E+11

scientific.JPG
However, when I open the csv file in notepad, it displays the format I need.
"ACCOUNT_NUMBER","INVOICE_NUMBER"
"100000309953","202250172428"

scientific_1.JPG
My question is, how can I import the desired notepad value (100000309953) using ssis when the csv file has them recorded as a scientific value (1E+11, 2.0225E+11)?

Is there a way to convert the csv file to a txt file format, or is there way that I can use SSIS to convert the scientific value.
0
Comment
Question by:barkome
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 40

Expert Comment

by:lcohan
ID: 41778593
I suggest use SQL Import/Export wizard and btw - in EXCEL, just make the columns bigger and you'll see the actual value....
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 41778594
What you see in the 'text' version is what you are actually getting.  You need to tell Excel to treat those columns as text to get the same display.  This is a common occurrence where the 'text' is all numbers.
0
 
LVL 26

Accepted Solution

by:
Shaun Kline earned 500 total points
ID: 41778595
The CSV file does not have the values in scientific notation. Excel is displaying them in that format. You should not need to do anything special to import the file using SSIS.
0
 
LVL 40

Expert Comment

by:lcohan
ID: 41778597
how to "Start the SQL Server Import and Export Wizard"
https://msdn.microsoft.com/en-us/library/ms140052.aspx
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
[Unsupported] SQL Update in CRM 2011 Database 19 62
get count of orders by customer Sql Server table. 3 46
mssql 7 32
T-SQL Query 9 34
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question