Hi - I currently have a DTS package that takes raw data from a SQL
table and inserts records into several tables via a custom ActiveX
transformation. The package uses logic to determine which table to
insert into and then calls DTSlookups to perform the inserts. The #
of records I'm working with is small (3,000-10,000). If I perform a
"test, the rows are actually inserted, and rather quickly. If I
execute the package through normal methods, the execution takes several
hours and often times out?

Any Ideas??

I would be looking at things like

Newtork Links
Resources on the servers

I would also be looking to profiler to help narrow down the problem and see
what statement in particular is causing the issue.


--


Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com



<clawdaddy (AT) gmail (DOT) com> wrote