I set up an SQL stored procedure which executes a DTS package. The SQL
stored procedure reads a table with 75 branch #s. It passes a different
branch # to the DTS package and then executes it. The DTS package uses the
branch # change the data source for the destination table and to query a SQL
Server table in a DTS task to transmit the data to an Access database. The
amount of data is the same for each branch. After about 6 branches were
complete, the system slowed down to a crawl. When running DTS packages
through a stored procedure and within a loop, is it necessary to release
system resourses and if so how is this done?