Good Day,

I would go with Elliott Whitlow on this one.

I think it's important that we dont leave out the ultimate goal. Which is to eventually dump the data into a ".txt" file. SSIS is your best option to achieving this goal.

Also you want to manipulate (Transform) the data before dumping it into the destination (".txt") file. Again SSIS is great at doing this.

But the important decision here is whether you want to use the functionality (the manipulation part of the data) in other instances (objects) or not. If so, you are better off using Option 2, if not, option 1 is the best solution (Also note that option 1 is re-usable as well ;-)).

Option 3 is a NO, NO!!!!