I'm importing a flat file into SSIS which needs to be split into two tables. In my input file I have a few columns (just an example.. I'm not really working with boxes): Box contents, box weight, box ...

The importance of automating processes can’t be overestimated. Most things start out as a manual procedure until you work out exactly how things should happen, but many times they stay that way ...