When it comes to converting ... SSIS wants the new column to maintain the original data type. As shown in Fig. 3, even though we have applied to DT_I8 cast, the data is still a four-byte signed ...

Importing data from Excel to SQL Server requires going back in time ... The drivers that connect to Excel are 32-bit and when your SSIS package runs, it wants to run in 64-bit.