July 19, 2002 at 8:45 am
I have a DTS Package which runs another package via an execute package task. This schedules OK, but when i include an analysis service task in the child package it fails to run. Any ideas?
July 19, 2002 at 1:12 pm
The analysis services process cube task is written in vb. VB is not multi-threaded therefore you have to make sure that the tasks in your package are set to execute in the main package thread. To do this, right click on each task and select workflow, workflow properties, options tab and under Execution make sure that the Execute on main package thread is checked...in MSDN you can search under Exception_Access_Violation+DTS to find info on this subject. In BOL, you can find information by searching under Parallel Execution.
hth,
Michael
quote:
I have a DTS Package which runs another package via an execute package task. This schedules OK, but when i include an analysis service task in the child package it fails to run. Any ideas?
Michael Weiss
Michael Weiss
July 22, 2002 at 2:49 am
that's running fine now,
Thanks
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply