😀 YES FINALLY!!!!! Thanks to you!
So:
1. The SSIS Package picks up and imports the correct columns from all 4 flat files
2. The database datatypes are all correclty amended to accept the SSIS import
All working fine, (He says) iv now passed the application onto the users to test, see how they get on....you never know, I maybe back...:Whistling:
Thanks for your time.