October 21, 2008 at 2:11 pm
Hey Friends,
I am getting this very wierd message.
Situation is:
I have created few packages on my local machine. When I run those packages, all those are turning green (running fine). But, there is an exclamatory yellow (warning) sign that pops up in the right hand corner of the start menu bar on the desktop with the message as:
Windows – Delayed Write Failed
Windows was unable to save all the data for the file share point path. The data has been lost. This error may be caused by a failure of your computer hardware or network connection. Please try to save this file elsewhere.
Now, the scene is that I tried to deploy these packages with this warning sign along with the other packages without the warning sign on the test server. All the other packages without the warning sign are running fine on the test server, but the packages that were having this warning sign are showing errors in the test server also.
The error that I get in the test server is as follows:
Executed as user: UserName. ...sion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 3:37:02 PM Error: 2008-10-21 15:39:56.03 Code: 0xC0202009 Source: ExcelSheetName Connection manager "ExcelFileName" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. End Error Error: 2008-10-21 15:39:56.03 Code: 0xC020801C Source: Data Flow Task Name (OLE DB Source) [293] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "ExcelFileName" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2008-10-21 15:39:56.03 Code: 0xC0047017 Source: Data Flow Task Name DTS.Pipeline ... The package execution fa... The step failed.
I tried to google for this issue, but I did not get a satisfactory answer for the same.
We will not be able to change the sharepoint path for this files.
Just to mention here, we are using a sharepoint path here as our source and sql server as our destination.
I would appreciate if any one of you could use your wisdom and help me get out of this problem.
We are almost at the end of the project, but we are stuck with this wierd issue. So, any help would be greatly appreciated.
Thank you all.
- notes4we
October 21, 2008 at 2:57 pm
Are you trying to import from an Excelfile here, which you had locally on your machine ?
If so, check the path to that filegiven on the package.
Maybe it points to the original position of the file on your local machine.
The service running the package on the servers probably doesn't have the right to access the file there.
devloping robust and performant databaseapplications with Microsoft SQL-Server
October 21, 2008 at 11:03 pm
While deploying are you selecting connection manager for excel file in configuration file? If you are selecting connection manager for excel file in configuration file, make sure that username, password properties of excel file are not selected. Try to select minimum properties like filename, file path in connection manager.
I experienced the error when i selected all properties of excel connection manager. Selecting username, password results in error AcquireConnection method call to the connection manager "ExcelFileName" failed.
Try out, it should work.
October 22, 2008 at 6:09 am
Hello,
Thank you for your replies. I will check and let you know if it works.
- notes4we
October 22, 2008 at 7:12 am
This is just to let you know that we are now able to get rid of that error message.
We changed the share point path of the files that were not running to make those consistent with the ones that we running and finally that error is no more.
I had mentioned in my original post that we do not wish to change the path, but then the team members agreed for the same and this is working well now.
Thank you.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply