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?
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.
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 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy