latingntlman (2/25/2013)
I've been tasked in creating an ssis solution which extracts data once a day, loads specific fields and exports them to a .txt file (pipe delimited), As the final step, it uploads the file via FTP to a source. I've accomplished all these steps successfully, however, I was just asked if the file uploaded could be cumulative since it's uploaded daily,and this is where I'm drawing a blank to fullfill this request. I'm not sure what I need to do additionally to finalize this solution with the cumulative uploads. Any light shed will be appreciated, as always.Thanks,
John E
Can you be a bit more specific about what 'cumulative' means in this case?
Is the problem that you are doing a full extract every day and the requirement is for changes only?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.