64-Bit SSIS and 32-Bit Excel Importing data from Excel to SQL Server requires going back in time, so to speak. Yes, back to 32-bits at runtime. By Eric Johnson 06/21/2010 As much as it can be a ...

When building an SSIS package, you probably find that a lot of the time you don't want one bad row to blow up the whole ETL. Many of the data flow tasks include the option to redirect errors down ...