It gains its speed advantages by using the bulk insert features that are built into SQL Server. Whata#39;s nice about this destination is that you can perform transformations earlier in the Data Flow and actually load data quickly in bulk into SQLanbsp;...
|Title||:||Professional Microsoft SQL Server 2012 Integration Services|
|Author||:||Brian Knight, Erik Veerman, Jessica M. Moss, Mike Davis, Chris Rock|
|Publisher||:||John Wiley & Sons - 2012-03-14|