[b]Query vs DTS SQL Task Performance[/b]

[Meleagant]

All,

I have a SQL query that performs an insert; we're talking about 20 columns X 150,000 - 250,000 rows depending on the month. Normally from SQL Query Analyzer this query, actually I execute it via a stored proc, will take anywhere from 8 - 12 seconds to finish. Unfortunately this query is one step in a chain and in an effort to break away from MS Access (where this process was kept before) I threw the whole thing into a DTS. But the same 8 - 12 second query run from SQL QA, takes a good 3 - 4 minutes when run from DTS. Can anyone tell me why?

Thanks,
-- Joe --

Journeyman -- The Order of the Seekers of Truth and Penitence

 

[DrSql]

Why dont you exeute bit methods and run profiler to see where is the bottleneck.

Dr.Sql
Help! I can't find your email address. What is it?
Good Luck.

 

[Meleagant]

Bit methods?

Journeyman -- The Order of the Seekers of Truth and Penitence

 

[DrSql]

Sorry.. Both methods..

Dr.Sql
Good Luck.