There is a screenshot here [1]. The trick is to choose the generic "import data" task rather than "import flat file". Then you have a wizard that lets you pla

There is a screenshot here [1]. The trick is to choose the generic "import data" task rather than "import flat file". Then you have a wizard that lets you play around with the specifications, change things up, look at the errors, go back to tweak things, go forwards to try again, etc. The only improvement I can think of is if you could save what you did as a standalone SSIS package (or whatever). [1] https://www.mssqltips.com/sqlservertutorial/9248/import-and-export-data-with-sql-server-management-studio/ https://www.mssqltips.com/sqlservertutorial/9248/import-and-...