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.