I don't have a lot of expertise with SSIS but when I create a simple package (source "Excel" and dest "SQL Server"), I run into some issue and wondering if I can get some help.
I have an excel sheet (source) with handful of columns but when I preview it, it shows some values as NULL for "Ticket Number" column and I know why because this column has 2 types of data. For example, the column name "Ticket Number" has 2 types of values
1. integar value (68452135121)
2. 8AP97LP1N which shows as a NULL value when I hit preview.
How do I resolve this issue?
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]