Run entire package

Hello,

i have a problem that i don't understand why it occurs: i have a package like this (resumed and ordered by its correspondingdata flow):

1. move data files to a path through by a file system task

2. import data of data files to a sqlserver database (each file through its own data flow). The origin of data is in files that have been moved to the path of step 1

3. execute a procedure of database (sql task) to manipulate data and finally export resume (data flow) to a new file in the path (moved by other file system task)

PROBLEM: if i execute the package task by task (one by one), it runs ok, but then when i build and run package as a whole (debug), it produces an error in the data flow such as it doesnt' find the path to take data of data flow (it doesn't find the source). Really it doesn't find source because the data files aren't in its correct path (like step 1 had failed). In summary, it looks like if the order of the task of package aren't correct when i execute the entire package, because the log doesn't thread any error about step 1 (file system task).

ERROR MESSAGE: an OLE DB error has occurred. Error code: 0x80040E37

Thanks for any help.

Gema

I'm not really sure if this is you issue, as the limited error you gave doesn't quite fit, and you don't say which task that relates to. A common issue which I would expect to occur here is that your data flow may fail validation since the files it expects cannot be found, as validation takes place before they have been moved by your file system task. To fix this type of issue, set the DelayValidation property to true for any tasks that depend on resources that are created or maintained by previous tasks. So set your data flow task to DelayValidation = True, so that it will only be validated just before it executes, and after the file system task has moved the files to the correct location.|||

Thanks a bunch!

That was my problem.