DTS Copy File Issue

[mcfly1204]

I have a DTS package that gathers data from some tables, opens Excel, creates a workbook, adds a worksheet, inserts the data into this worksheet and then saves the workbook to a specified location. I added a step that copies the workbook to an additional location. One problem, the file copies, but the added worksheet does not. I created a test DTS that simply copies the file, and the new worksheet is copied over. What step am I missing in my original DTS package?

[antonopn]

Check if the task of copying the already exported workbook is done ON COMPLETITION of the first task.

I can imagine that your process copies a table that is not created-saved yet.


Nikos