Re: SSIS: something is seriously wrong

#1

The hotfixes and SP could be an issue (I have heard a slow down from
someone else). Remember though that the package when you execute in a
job and in BIDs on your PC will be executing in 2 completely different
places.

--

Regards

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

"Nadia" <Nadia (AT) discussions (DOT) microsoft.com> wrote

Quote:

when I run a dtsx package through Business Intelligence Studio it takes
1
second to run... when I deploy the package to my sql server and right
click
to run the package it takes 1 second.

But when I run the package through a job OR use the xp command shell to
run
the dtsx package it takes 2minutes.

What is going on.... why would the package run so fast in the Business
Intelligence Studio yet so extremely slow through a JOB.

After I installed SP1 it got bad, but after I installed all the
hotfixes,
it's just become unbearable.

#2

Nadia wrote:

Quote:

Thanks Allan, Question. Is there a way to get the job to execute in
the same place that the BIDs do.

When you run these in Business Studio they are running on YOUR PC. When run
from an Agent job they run on the PC where SQL Server is installed.

Do you perhaps have a faster PC than the server?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

#3

If you go to the server and execute the package interactively through a
job and it is lightning fast and you then schedule the package and it is
slow then you have negated the server as being an issue.

Where exactly is it costing you time? Can you narrow it down to a
particular part of the package?

--

Regards

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

"Nadia" <Nadia (AT) discussions (DOT) microsoft.com> wrote

Quote:

The BIDs and the SQL Server Agent are both on the same PC as of now....

What extra steps is the job taking???... because if I am in the SQL
server
and I right click the stored package to run it, it runs just as fast as
if I
ran it through BIDS, but when I set it up through a job, it takes
forever to
run.

"Rick Brandt" wrote:

Nadia wrote:

Thanks Allan, Question. Is there a way to get the job to execute in
the same place that the BIDs do.

When you run these in Business Studio they are running on YOUR PC.
When run
from an Agent job they run on the PC where SQL Server is installed.

Do you perhaps have a faster PC than the server?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: SSIS: something is seriously wrong

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: SSIS: something is seriously wrong - 12-18-2006 , 05:39 PM

Re: SSIS: something is seriously wrong - 12-19-2006 , 10:59 AM

Re: SSIS: something is seriously wrong - 12-19-2006 , 02:55 PM