I have done 2 basic data transformations using ssis 2012 on sql 2008, one of which is giving me problems.
The scenario is that as a source I have an odbc link to some data files and as a destination am using sql native 11.
The 2 problems I have are;
a) if the destination table is set as fast load, speed is good but stops at 11989 records
b) if destiantion table is set as table/view, it takes a very long time to complete on large tables.