June 3, 2013 at 10:29 am
I'm building a SSIS package with various steps to import CSV files, upload to temp tables, update, copy to other tables etc.
I want to step through the package and execute 1 task at a time and verify it worked correctly. I can execute the task, but it seems to put it into debug mode and I have to stop debugging after each task runs before I can execute the next task.
I don't care about debugging. Can I stop debugging from getting started so I can just run each task manually, check results, run the next task etc ... ?
June 3, 2013 at 10:38 am
You can right-click on a task and select 'Execute Task' - is that what you're after?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
June 3, 2013 at 10:46 am
That is what I do. Then it goes yellow as it runs, and I hope green when it completes. But I cannot right click/execute the next task without first going up to the debug menu option and selecting "stop debugging", even though I never (intentionally) started debugging.
Is there a debug default option I can turn off ?
June 3, 2013 at 10:53 am
homebrew01 (6/3/2013)
That is what I do. Then it goes yellow as it runs, and I hope green when it completes. But I cannot right click/execute the next task without first going up to the menu bar and selecting "stop debugging", even though I never (intentionally) started debugging.
Ah, OK - I see your point.
I think that you are tacitly assumed to be 'debugging' just because you are running the package interactively from VS - as far as I know, there is no way of turning that off. Would be a useful setting though.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
June 3, 2013 at 11:34 am
I am not sure how much this will help but individual task can be run from a package. You have to use Expression between tasks. A look in this article might help you but this is a slightly different approach.
SSIS: How to run specific task of SSIS package programmatically from windows/web application?
Vikash Kumar Singh || www.singhvikash.in
June 3, 2013 at 11:34 am
If I have 10 tasks in my package, can I select & run the first 6 all together ?
Then I can check output before running the next 4.
June 3, 2013 at 11:43 am
Yes, there is two way.
1. You can Disable the last 4 task and running the package to see the output of first 6 task.
2. If you want to run the package through web/windows program you have to customized the first 6 task expression in a way that they runs first.
Vikash Kumar Singh || www.singhvikash.in
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply