I tried to upload the Masterfile text file using different separator options in the uploading step but the issue on season code for Superdry is still two letters instead of the 3 letters which is the correct one. Watch tutorials on youtube on how to import text file into the database as suggested that to leave all options to default, I did try to it and got the same result. Duplicate the setup used in the 1.13 server to setup the Masterfile package in the SQL Jobs, I think the SQL Server 2000 version is pretty straight forward there are no many options to choose from unlike from 2008 R2 version it displays different like format is it delimited, header row delimiter. I did use my old setup up in integration services when I set up the 11.17 server before the rachet server is for decommissioning and switch it up into the task scheduler. I will check in tomorrow for the result.