Hi,

I need to upload data from multiple excel files and in each files there
are bound to be more than one worksheet. I came across a very good
sample on how to achieve this at sqldts.com.

I have set up an individual DTS for uploading of each excel file and a
create a parent package to execute all the dts via Execute Package
Task. I need to configure such that when any of the individual package
failed, it would do a rollback. However, when executing the parent
package, the task cannot seems to finish executing on the Execute
Package task.

I have checked the Execute on Main Package Thread and yet it seems that
it is waiting for "something" before it can finish or move on to the
next task. I am not sure what went wrong. Any help would be greatly
appreciated.

Thanks

-- Jordan