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 ...

I have never used SQL Server Integration Services before and need to extract data out of several Access databases, then transform it and load it into an SQL Server table. Migrating data from Access to ...