SQL2005 SSIS Query Performance

#1

In SQL2000 DTS you could execute a package from the DTS designer and see how
long each step took. Is there any way to do this in SQL2005 SSIS?

--
Jeff Lynch
"Ramblings From A [Microsoft] Connected Universe"
http://codebetter.com/blogs/jeff.lynch

#2

Hello Jeff,

In SSIS project in VS 2005, you could also right click each task->Execute
task to execute the task. You could run the package by "ctrl +F5".

Also, after you import the package to SSIS, you could connect to SSIS in
SQL server management studio, and right click the package you want->Run
Package

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

Quote:

From: "Jeff Lynch" <jeff.lynch (AT) newsgroup (DOT) nospam
Subject: SQL2005 SSIS Query Performance
Date: Wed, 21 Dec 2005 15:53:48 -0600
Lines: 10
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
Message-ID: <e0zIHknBGHA.1864 (AT) TK2MSFTNGP12 (DOT) phx.gbl
Newsgroups: microsoft.public.sqlserver.dts
NNTP-Posting-Host: gateway.gulfcoastseal.com 65.212.192.66
Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP12.phx.gbl
Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.dts:62688
X-Tomcat-NG: microsoft.public.sqlserver.dts

In SQL2000 DTS you could execute a package from the DTS designer and see
how
long each step took. Is there any way to do this in SQL2005 SSIS?

--
Jeff Lynch
"Ramblings From A [Microsoft] Connected Universe"
http://codebetter.com/blogs/jeff.lynch

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

SQL2005 SSIS Query Performance

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

SQL2005 SSIS Query Performance - 12-21-2005 , 03:53 PM

RE: SQL2005 SSIS Query Performance - 12-21-2005 , 11:17 PM