I am attempting to load a number of Excel files into a SQL Server 2005 database. When I connect the Excel Source component it automatically makes all text fields a Unicode string (DT_WSTR) of length 255.
If I attempt to change the size or type I get an error that "...the error output has properties that do not match the properties of its corresponding data source column."
It then won't let me change the type of the error output, which I'm not even using.
Why is it forcing me to make the data type of my output the same as it's incorrect guess for the type of the error output?
Is there any way around this?