Highlight the step in the SSIS package you want to run, specifically, then right click and select Execute.
Or just right click it and select Execute, however you have to make sure, particularily in a multi-step SSIS package, that the one you're about to execute is actually the one you want... which is why I said to specifically highlight/select it first.
The Excecution Results tab will give you some information on how far the process got depending what is involved, as does the Output tab but in slightly more detail than Execution Results. If you can't see the Output tab Ctrl+Alt+O will bring it up or go the the View menu and select Output.

Thanks,

Jeremy Greaves
Fenris Software Consulting, Inc> To: [Email address protected] From: mssqldba-ezmlmshield-x78376974.[Email address protected] Date: Thu, 29 Nov 2007 13:11:57 +0200> 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>
MS Sql Server LazyDBA home page