• ...if I change the Recovery Model to Bulk-Logged, will that prevent the log files growing substantially during the process, or would I be better off if I script an export via an SSIS package?

    ...

    Why do you expect using SSIS will avoid database log file growing?

    You will be better off with SELECT INTO and minimum logging using Simple or Bulk-logged mode (depending on log policies around your place)

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]