Unanswered: Suggestions? - SSIS export then import data from stored procedure
I just wanted to get some best practices advice; I have a db which I need to export the data from one table (daily, via SSIS probably) to an ftp site where it will be imported (via SSIS, likely) into another SQL db.
My boss is a little old fashioned and doesnt want it done with SSIS's ability to copy db objects, so my thought lean towards CSV and XML files.
Does anyone have any similar experiences that they would share, or suggestions one way or another with import / export via SSIS?