I'm using a Microsoft.Jet.OLEDB.4.0 as the connection manager to move the data into an Excel file, but now when I chose the file, I get this:

TITLE: Connection Manager

------------------------------

Test connection failed because of an error in initializing provider. Unrecognized database format 'C:\Temp\Test.xls'.

But when I use an Excel Desination, I keep getting a message saying "cannot convert btw unicode and non-unicode string..." this persists whether or not I use a data converter.

I'm obviously missing something.