FINALLY! 🙂

I just wasted tons of time on this problem... but I see what my mistake was...

I also had a problem where when exporting to Excel all my data types would always get converted to 255 characters unicode string (WSTR). This was despite the fact that everywhere else in my package the data types used were money, int, nvarchar(10), etc...

I generated a package using the wizard to see what the wizard is doing differently then I was (cuz with the wizard everything works fine)

The problem was with how I was creating the excel sheet (aka destination table) in the 'Excel Destination' component.

My code was

CREATE TABLE `Before7AM` (

`CustomerID` NVARCHAR(10),

`TranCount` INTEGER,

`TotalVolume` MONEY

)

But for some reason I had to change the code to this for it to work:

CREATE TABLE `Before7AM` (

`CustomerID` LongText,

`TranCount` Long,

`TotalVolume` Currency

)

Also I had to move the creation of the destination table out of the 'Excel Destination' component to a separate 'SQL Task' component. Not sure why... So it seems the problem was mismatch of data types names...