June 23, 2008 at 8:27 am
I'm still in the learning process of using SSIS as my ETL processes and have a question of how to parse an Excel to a table.
Below are the data before parsing it.
BEGIN_DATE END_DATEPercent1 Percent2
1/1/2006 12/31/9999 -
4/1/2007 12/31/9999100% Percent100% Percent
1/1/2006 12/31/99991
7/1/2006 12/31/99990.45 35%
7/2/2006 12/31/99990.65 17%
Attached is what I got from the SSIS Excel Source Editor - preview. The 100% Percent turned into NULL values and the rest are fine. Any idea why? How to i fix this? TIA to all the geniuses...
June 23, 2008 at 9:07 am
Please don't cross-post
http://www.sqlservercentral.com/Forums/Topic521867-148-1.aspx
June 23, 2008 at 9:16 am
Sorry..i've deleted my post on the General Discussion board but it's still showing..
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply