>I'm using SQL 2008 R2.
>
>I need to copy the 4 million rows of data from Table A into Table B. The column names do not match, and I will need to adjust the data widths to avoid truncation.
>
>1) I am fairly new to SSIS. I have an OLE DB Data Source and an OLE Destination. Are these to only objects I need?
>
>2) Can someone point me to a decent book or tutorials?
>
>Thanks
Pluralsight has a good course:
http://www.pluralsight-training.net/microsoft/courses/tableofcontents?courseName=ssis-basic