Thanks for the lovely article... this is my first effort at SSIS.

I am trying to do the same steps, in this second article, but on our databases. I am getting a data error.

Error1Validation error. Data Flow Task: Data Flow Task: Column "MRP_Area_CD" cannot convert between unicode and non-unicode string data types. Package.dtsx00

Both source and destination tables have the same data type, so I guess this is something that SSIS is doing, how do I fix it?

From the alter table code...

[MRP_Area_CD] [varchar](10) NOT NULL,