In contrast, a regular INSERT statement retains the null value instead of inserting a default value. The INSERT ... SELECT * FROM OPENROWSET(BULK...) statement provides the same basic behavior as ...
[!INCLUDE[sqlserver-ssis](../../includes/applies-to-version/sqlserver-ssis.md)] [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Import and Export Wizard is ...