I set up a DTS package as a structured storage file. It runs several sub
packages including data transform tasks to import data, SQL tasks to execute
SQL stored procedures, and data transform tasks to export data. The data is
imported from and exported to an Access database residing on a network drive.
Sometimes the entire package runs in 13 minutes. Other times, the package
runs extremely slow when it reaches the data transform task to export data.
After 45 minutes I stoped the package and then ran the export package
independently and it ran in 5 minutes.

1) Is there something which would account for this behavior ?
2) Is it recommended to run data export packages separately from the main
package or could some parameter be set to assure that the proper
resources
are allocated for the data export ?
3) Would it be more efficient to run it as a SQL Server local package than a
structured storage file ?

Speeding up DTS package Structured Storage File vs SQL Server