Is basic file reformatting a valid use case for SQL Server Integration Services (SSIS)?
Is using SSIS to do reformatting of flat files from one format to another (not using a database; just flat file connections) a common practice, or is it like using a sledgehammer to drive a nail? The reason I ask is that at the company I currently work for we have production personnel (some not too tech-savvy) using an in-house programm...