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.
Friday, April 4, 2014
SSIS fails
Posted by Radu at 10:40 AM 0 comments
Subscribe to:
Posts (Atom)