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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-06-11 : 09:53:28
|
| Kiran writes "Hi All,I have been facing problems with Cascading DTS packages.Assume I have two pacakges i.e. parentDTS and childDTSThe childDTS will be called from the parentDTS package after some SQL tasks in the parentDTS packageNow, if the childDTS package has tasks related to Analysis server like rebuilding dimensions or cubes, the parentDTS is unable to trigger the childDTS packageHowever, if the childDTS package has normal sql database related tasks, then the parentDTS is able to trigger the childDTS package.Now,I'm not sure why this problem. Is this something to do with SQL Server configuration or any other configuration or is this just me ?:-)" |
|
|
|
|
|
Problems with cascading DTS packages