October 22, 2009 at 2:33 pm
When I create an Excel source in SSIS, it is automatically assigning a numeric data type to a field that should have a string data type. When I go into "Advanced Editor --> Input and Output Properties --> Output Columns" to change the data type, there is a black box next to the DataType property that just closes down the editor when clicked.
Is there anything I can do at the source level to change the DataType? What other alternatives do I have?
October 22, 2009 at 2:51 pm
I kind of remember hearing about this before. I believe the resolution was to uninstall/reinstall SSIS and/or Excel.
An alternative solution would be to use a Data Conversion transformation after your Excel source.
October 22, 2009 at 3:42 pm
You might be able to re-apply a service pack to resolve this.. Not sure though.
CEWII
October 23, 2009 at 10:11 am
Erik Kutzler (10/22/2009)
I kind of remember hearing about this before. I believe the resolution was to uninstall/reinstall SSIS and/or Excel.An alternative solution would be to use a Data Conversion transformation after your Excel source.
Thanks for your reply.
I'm fine with using a Data Conversion transformation. Unfortunately, since this field is being treated as numeric, the alphanumeric values are set to NULL when SSIS pulls in the Excel file, so any conversion I'd apply would be useless.
Does anyone else have experience with this issue? I suppose I'll wait a little longer to see if there is another resolution outside of uninstalling SSIS and/or Excel, as I'd like to avoid going that route.
October 23, 2009 at 10:31 am
Don't do the deinstall, it won't fix this.
Sounds like an Excel driver 'feature', see here[/url]. You could try the solutions offered there. Or ...
Try adding a column to the right of your current spreadsheet data which forces the issue:
=TEXT(B1,0)
=TEXT(C1,0)
etc etc
and then importing that column instead.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply