Member Avatar for moone009
moone009 0 Junior Poster in Training

I have an ssis package the loops through an entire folder importing records into a sql 2005 database.

I pull these records from a table in my database through an "execute sql task" then that gets pushed into the foreach loop container. However when one of the filenames is missing from the folder it errors out my flat file destination and will not move on to the next. I tried diverting it to an error handler but no such luck.

BID 2005 Dev Ed

Any Ideas?

  • 1 Contributor
  • 0 Replies
  • 89 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.