Kutang Pan (3/4/2015)
- are you getting an error message?- did you remember to add
using System.Data.OleDb;at the beginning?
- did you try to debug and find out at which line it fails?
- make sure that your For Each Loop has Max Error Count more than one so when a connection fails it won't stop the whole package and will loop to another connection.
- Also change the Max Error Count for the package as it will report failure if one of the connections will fail
just to interject a question,does the package have to keep running after any error occurs or just if the connection fails go to the next one & if any other failure fail the package