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 programming language to write custom programs to do file reformatting/data transformation. My thought after breifly looking at and playing with BIDS and SSIS is that building a package with the GUI would seem to provide a substantial productivity boost over them having to write custom reformatting logic. I'm just wondering if this is a common usage scenerio?
[edit]
The reformatting/data transformation performed can range from the basic cleanup (justification/casing adjustment/filling) to complex stuff where pieces of data may be handed off, processed in various ways, and returned.
There definitely will be automation involved in some cases (as that is one of the reasons I started looking into this in the first place). I already discussed this with one of our network guys and we do have these tools and licenses available to use, so the cost is not an issue.