October 12, 2008 08:40pm pdt

1. chapmandew 138,810
2. acperkins 103,316
3. nmcdermaid 85,012
4. cs97jjm3 49,219
5. mark_wills 44,985
6. angelIII 41,135
7. PedroCGD 40,580
8. brejk 36,600
9. EugeneZ 36,222
10. frankytee 27,691
11. dready 20,000
12. matthews... 18,750
13. bhess1 16,550
14. aneeshatti... 14,002
15. Zberteoc 13,800
16. rickchild 13,750
17. momi_sa... 11,250
18. rboyd56 10,525
19. MohammedU 10,325
20. dbaSQL 9,815
21. Yveau 9,700
22. dtodd 8,868
23. JimFive 8,375
24. TheLearn... 7,830
25. dbbishop 7,800

1. acperkins 371,565
2. nmcdermaid 197,729
3. angelIII 181,551
4. arbert 149,684
5. chapmandew 138,810
6. EugeneZ 87,040
7. matthews... 56,804
8. cs97jjm3 55,749
9. aneeshatti... 47,999
10. mark_wills 44,985
11. rboyd56 42,625
12. PedroCGD 42,080
13. ptjcb 38,638
14. brejk 36,600
15. bhess1 36,130
16. twoboats 30,515
17. frankytee 30,441
18. dready 30,430
19. Yveau 30,000
20. Sirees 27,902
21. jltoops 27,275
22. Lowfatsp... 24,059
23. TommyTupa 23,000
24. gbshahaq 22,472
25. ScottPletc... 22,430

05.28.2007 at 06:17PM PDT, ID: 22598727

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

5.4

This action cannot be completed . . . when saving Excel file within DTS

Asked by klgrube in MS SQL DTS, MS SQL Server

Tags: action, cannot, excel, completed, file

Okay, I'm reposting this because I never got an answer and I REALLY an answer to this. Please help.

_____________________________________________________________________________________'

Hi!

Hope someone can help! In case this looks a bit familiar, that's because it's the last comment on a slightly more complex question I had a while back, but I never got a solution to this part of the problem and I really need help.

Not sure why, but when I execute the following step from within the SQL Server 200 DTS designer on a little Windows 2000 server, I get an error message that says:

SERVER BUSY
This action cannot be completed because the other program is busy. Choose 'Switch to' to activate the busy program and correct the problem.

Usually, if I hit retry three or four times, the step completes successfully. But when I execute the package from the Enterprise manager, it always fails.

Any Suggestions?

'**********************************************************************
' Visual Basic ActiveX Script
'************************************************************************

Function Main()

Dim sSourceFile
Dim sDestinationFile

Dim oFSO
Dim e_app
Dim e_wbook

Main = DTSTaskExecResult_Success
Set oFSO = CreateObject("Scripting.FileSystemObject")

sSourceFile = "\\Server1\Inetpub\wwwroot\Company_Metrics\Metrics Template.xls"
sDestinationFile = "\\Server1`\Inetpub\wwwroot\Company_Metrics\Company Metrics.xls"

if oFSO.FileExists(sSourceFile) then
If oFSO.FileExists(sDestinationFile) Then
oFSO.DeleteFile sDestinationFile
end if

Set e_app = CreateObject("Excel.Application")
Set e_wbook = e_app.Workbooks.Open(sSourceFile)

With e_wbook
.SaveAs sDestinationFile
.save
End With

e_wbook.Close
Set e_wbook = Nothing
e_app.Quit
Set e_app = Nothing
else
Main = DTSTaskExecResult_Failure
end if
Set oFSO = nothing

End Function

====================================================================

The file I'm trying to open and 'Save As' is about 20 MB before the Save As and about 16 MB after, which is exactly why I'm trying to do the SAVE AS. I think the problem is that the Open may be taking too long or the Save As is taking too long or something. I'm not sure. Can I turn that message off or something?

Karen
Start Free Trial

Keywords: This action cannot be completed . . …

	Title
1	Wait 10 seconds in DTS package
2	ActiveX script in DTS package
3	Expected Identifier Error in ActiveX Scr…
4	DTS insert error
5	DTS ActiveX VBScript Shell and Wait f…
6	How do you create a table in a spread …

Loading Advertisement...

20080924-EE-VQP-38

This action cannot be completed . . . when saving Excel file within DTS

Asked by klgrube in MS SQL DTS, MS SQL Server

Tags: action, cannot, excel, completed, file

About this solution