2

I'm downloading CSV files using FTP and I loop through them to import into a MS SQL staging table. What I want to do is move successfully imported files into an archive folder and move failed files into a failed folder.

My problem is that I can't find a way to have a red error/failure arrow coming out of my Data Flow Task, and inside the Data Flow task, where I can see the red arrow coming out of the OLE DB task, I can't find a way to have a File System Task!

Am I missing something obvious?

Data Flow Task

enter image description here

Amarundo
  • 2,357
  • 15
  • 50
  • 68
  • Sorry... figured it out... I said I was missing something. How do I delete this question from my history??? – Amarundo Jul 06 '15 at 21:33

1 Answers1

3

Just grab a green arrow coming out, connect it to the next step and then right-click on the green arrow and change it to Failure.

Amarundo
  • 2,357
  • 15
  • 50
  • 68