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
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people