March 13, 2009 at 2:43 am
Hi All,
My package is transferring records from SQL Server to CSV file.
There is a column called
Column Name Data Type Value
Number Varchar 0000000563
I m unable to load the leading zeros into CSV file. The CSV loads from the first non -zero value like 563 from the last value.
Any help greatly appreciated
Thanks in advance
Regards
Priya
March 13, 2009 at 7:07 am
Can you post the details of how you are doing this? What are all the steps in the SSIS package/dataflow? Are you sure the data is being retrieved from the database using the right type and that there are no type changes within the flow?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 13, 2009 at 10:16 am
Double check in your flat file destination that the data type for that column is a String.
April 9, 2010 at 6:48 am
I am also having a very similar problem.
I have a numeric field, (18,2) that needs to be exported to a csv file, but when it gets exported any zero values are showing as '.00' and not '0.00' . i.e. the leading zeros are missing.
The connection manager for the Flat file has the column specified as a string. Putting a Data Viewer before the final Flat File Destination task shows the data in the correct format, but previewing the columns in the Flat File destination, shows the value without its leading zero....
Any ideas on how i can get this leading zero back in...Is there any particular format I need to use?
April 9, 2010 at 6:57 am
You could try putting a data conversion task in - to cast your numeric field as string - and then map the converted field to your destination, after manipulating the format if necessary.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
April 9, 2010 at 7:12 am
Have also tried that using a data conversion tool. But it does not seem to make any difference whether the format of the field has been set in a string or numeric format.
I'm pretty stuck.
April 9, 2010 at 7:20 am
Once you have a string field which contains, for example .75
you can add a derived column that prepends a 0
the string is then 0.75 and that is what will go into your destination.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
April 9, 2010 at 8:17 am
Yep...thats finally what I have had to do.
Seems strange though that the final task seems to transform the data on its own. even if u tell it not to!
April 9, 2010 at 8:25 am
Jason Coleman (4/9/2010)
Yep...thats finally what I have had to do.Seems strange though that the final task seems to transform the data on its own. even if u tell it not to!
That's just SSIS trying to be helpful:-D
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
April 15, 2010 at 4:16 am
any luck priya?
Rex Smith
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply