Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ying Zhang How to Handle NULL Values Loaded by SSIS from Excel Files RE: How to Handle NULL Values Loaded by SSIS from Excel Files

  • April 28, 2008 at 5:49 am

    #807681

    One could just save the Excel as a CSV file, load the file via BULK INSERT or OPENROWSET and be done.

    Why go through hoops on and develop SSIS package? The portability and predictability of SSIS isn't that great anyway.

    my 2 cents...