Notifications You must be signed in to change notification settings To save more than 255 characters to Excel file in SSIS, don’t use Excel Destination. It won't work except a few edge cases. Instead, ...

Log table in database (table containing info about loaded files (filedate and company name will extracted from filename. Successfully loaded files will be moved to archive folder) ErrorLog table (If ...