By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,379 Members | 1,404 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,379 IT Pros & Developers. It's quick & easy.

DTS Copy File Issue

P: 233
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?
Mar 27 '08 #1
Share this Question
Share on Google+
1 Reply

P: 42
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.

Mar 31 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.