Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQL_Rookie
Starting Member
32 Posts |
 Posted - 2008-02-26 : 15:52:43
|
| I have a parent package that calls a child package. When this is executed on SQL server (the actual server host SSIS services) it executes fine I can see data in the correct tables and I can determine that is ran. But I try to run this from my local pc within the designer (Visual Studios) and the parent package runs a few task that are before the child package task but once it gets to the child package it stops. I have set breakpoint on several task with the parent package and I can step thru them but once it gets to the child it tries to run it then the execute package task object turns red. I can not find any error messages or codes. I even have beak points set up on the child package itself and the process never hits those break points but I'm assuming is cause is puking before I get to the child package. The child package is stored in SQL server and is in MSDB. I just want to debug the child packages from BIDS or visual studios?any one know how to debug child packages from BIDS or Visual Studios?I can if I run the child package by itself but I need to test from end to end ....so within the parent packages which calls a few child packages..thanks |
|
|
tprupsis
Yak Posting Veteran
88 Posts |
Posted - 2008-02-26 : 17:02:12
|
| How do you have the Execute Package defined? File system or SQL Server? If file system, do you have access to the file location as defined in the task? |
 |
|
|
SQL_Rookie
Starting Member
32 Posts |
Posted - 2008-02-27 : 09:38:40
|
| defined as sql server. which leads me to another questionExecuting the SSIS packages in the designer (BIDS or Visual Studios) does the code execute locally on the workstation or does the packages execute on the dev sql server? I don't have sql server installed on the workstation and the packages all connect to eh dev sql server but does that mean it uses the dev sql server to execute the package and therefore all packages need to be loaded to the dev sql server? |
|
|
|
tprupsis
Yak Posting Veteran
88 Posts |
Posted - 2008-02-27 : 10:47:53
|
| In BIDS, the packages execute locally. I'm no SSIS expert, but I did run across something like this once. I believe the solution for me was to make sure the Distributed Transaction Coordinator service on my machine was running. |
|
|
|
|
|
|
SSIS child package not executing.