Hello.

I have a table that I have to split then copy to multiple Access files.
DTS looks like that:

1. ActiveX:
Setting some global variables, copying and renaming empty Access file
2. Setting dynamic parameters like SQL states to copy data from main
database
3. Copying data to Access file creating two tables in file
4. ActiveX: Finalizing export by encrypting file with PGP

The problem is that in most cases only one table is copied. The second one
is only created in file, but no data is copied.

Does anybody know what is wrong?

--
Pozdrowienia,
Igor 'Enzo' Zagañczyk
<rot13>ramb ng cbfg qbg cy</rot13>