You can do it a number of ways.
1. Right click and execute task
2. Right click all the other tasks and disable.
3. Set break points. This is the one I like to use as I can look at my
variables in the watch window and make sure they are what I expect.
PAYCHEX
Christopher Bellizzi
Information Technology * Database Administration
675 Basket Road * Webster, New York 14580
(585) 216-0670 * [Email address protected]
-----Original Message-----
From: Crafford R. (Ruan)
[mailto:mssqldba-ezmlmshield-x78376974.[Email address protected]
Sent: Thursday, November 29, 2007 6:12 AM
To: LazyDBA Discussion
Subject: SSIS
Hi all
How do you execute a single step in SSIS, i have a SSIS package thats
failing so i want to execute it 1 step at a time. Also, where can one
check in detail where and why certain steps failed??
Thanks
Ruan
********************
Nedbank Limited Reg No 1951/000009/06. The following link displays the
names of the Nedbank Board of Directors and Company Secretary. [
http://www.nedbank.co.za/terms/DirectorsNedbank.htm ]
This email is confidential and is intended for the addressee only. The
following link will take you to Nedbank's legal notice. [
http://www.nedbank.co.za/terms/EmailDisclaimer.htm ]
********************
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------
The information contained in this message may be privileged,
confidential, and protected from disclosure. If the reader of this
message is not the intended recipient, or any employee or agent
responsible for delivering this message to the intended recipient,
you are hereby notified that any dissemination, distribution, or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately
by replying to the message and deleting it from your computer.
Thank you. Paychex, Inc.
MS Sql Server LazyDBA home page