blogs.conchango.com

Someone emailed me today asking: I have an SSIS package that outputs data that can’t be inserted into destination tables into flat log files [JT: I presume he means that error rows are redirected to a flat file] What is the easiest way to then after processing has completed: A) Check to see whether there has been any data that could not be ...

Checkpoint files are very useful mechanisms for recovering failed packages and I have talked about them quite a bit before, however, they do have one or two limitations. One thing that people typically want to do is always execute a particular task regardless of whether a checkpoint file exists or not. There may be a number of reasons for this - ...