I was looking at the SSIS tutorial using the samples provided by MS and
found something interesting.

For 2008, I went through the tutorial and it works fine.

But what I did see was that the mappings do not show correctly even though
it creates the new table correctly.

I went in and change some types and some sizes.

But when I went to the Data Conversion task in the Data Flow section and
double clicked on it, I found that the it only showed the columns in the
details pane that actually had the data types significantly change. It
didn't show changes from nvarchar to nchar and didn't show length changes.
When you selected one where you did this it showed the original size. For
example, I had changed the size for FirstName from 255 to 50 and it still
showed 255. But if I looked at the table it created it did the mapping
correctly.

So the Data Conversion Transformation Editor was not correct.

Was curious if that was the case.

Thanks,

Tom