October 14, 2010 at 8:31 am
I am trying to export data from an oledb source to a destination file which is a csv file ,but i am facing the following issue.
input to CSV destination file: 01012010
but the CSV file has the value: 1012010 (first "0" digit is not getting displayed in the CSV file)
Could you please let us know how to resolve this issue.
Thanks in Advance.
October 14, 2010 at 8:45 am
marees.inspire (10/14/2010)
I am trying to export data from an oledb source to a destination file which is a csv file ,but i am facing the following issue.input to CSV destination file: 01012010
but the CSV file has the value: 1012010 (first "0" digit is not getting displayed in the CSV file)
Could you please let us know how to resolve this issue.
Thanks in Advance.
Edit the connection manager for the CSV file. Go to the advanced view for the columns and set that column to a string data type.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 14, 2010 at 8:52 am
I have tried that option...but still the same issue 🙂
October 14, 2010 at 8:55 am
How are you looking at the CSV file? With Notepad? Or Excel? Use Notepad.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 14, 2010 at 8:59 am
HI ,
When i am opening through notepad, i am getting the leading zeros.
but when i am trying to open through excel or CSV file as such leading zeros are not there.
how to resolve this 🙂
October 14, 2010 at 9:07 am
Edit the CSV file using Notepad. The zero will be there.
If you use Excel, it helpfully (:w00t:) guesses datatypes for you - numeric in this case, and therefore with no leading zeros.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
October 14, 2010 at 9:13 am
The problem is with Excel, not SSIS.
Edit: Oops. I see Phil's faster than I am this morning. 🙂
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 14, 2010 at 9:24 am
Alvin Ramard (10/14/2010)
The problem is with Excel, not SSIS.Edit: Oops. I see Phil's faster than I am this morning. 🙂
Afternoon here and I'm fully caffeine'd-up 🙂
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
October 14, 2010 at 9:27 am
Phil Parkin (10/14/2010)
Alvin Ramard (10/14/2010)
The problem is with Excel, not SSIS.Edit: Oops. I see Phil's faster than I am this morning. 🙂
Afternoon here and I'm fully caffeine'd-up 🙂
Mid-morning here and I'm just starting my 3rd cup.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply