Friday, April 4, 2014

SSIS fails

If you get an error at the running of the Flat File Source SSIS dataflow item
"Task Load {your flat_file} failed" while running a SSIS package (that loads data from a flat file) it might be that you have the flat file opened in Excel. Just for curiosity I tried opening the file in CSVed and it looks like CSVed  doesn't keep it locked, the task runs succesfully.

Hope this is saving you some hair pulling.