• hey,

    thanks for the reply,

    yeah excel just seems a horrid pain, ive been reading up on SSIS frameworks and such, and wondering what people do to make sure the data gets in there.. (most of our Excel etls fail at least once a week due to column widths.)

    if you cant garuntte the source file, do you make alterations to the load table? say make every col varchar(max) so you wont get errors loading it in then clean up after?