> Hi,
>
> I have created a package which transfers some table contents from a
> SQL Server database to an Access counterpart. An "Execute SQL Task"
> deletes the already existing data from the target tables and then,
> after the succesful completion of the operation, the transfer occurs.
>
> Unfortunately, there is a table that does not get filled with the
> corresponding data. Its content is deleted by the initial task and it
> remains like this, without receiving the input from the package. It is
> strange, because the package reports a complete succes and even
> displays the correct number of rows that are supposed to be
> transfered. Also, the accident occurs only when the target table has
> data to be deleted; if empty, the transfer executes ok.
>
> Do you know how should i manage this? I think it's about synchronizing
> some statements but i have no idea about how it could be done.
>

> Hello Allan, thank you for the replay.
>
> I have used green arrows only, all starting from the deletion task.
> The
> insertions should carry on only after this prelude completes.
> Something happens on the Access side, which is probably losing the
> insertion stuff on that table. By the way, it's the last table to
> delete from; the others are treated just fine