SQL job completing successfully but throwing the error

[manjulabaadal]

Dear Team,

Kindly advise how do I resolve the below issue:

Issue Description : I Have a SQL job scheduled to copy from local, refresh excel files and then upload to the SharePoint.

Job is doing all fine. It refreshes the file and upload to the SharePoint though it throws the below massage when checked the job history in SQL.

{Message
Executed as user: REDMOND\v-mahonn. Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 04:04:00 Error: 2014-01-23 04:13:51.41 Code: 0x00000000 Source: Refresh Excel FileVbnet C:\Scorecard\FilesToRefresh\Daily\Premier Screening\Vendor Loyalty report\~$Loyalty Survey Results EMEA.xlsx Description: Excel cannot open the file '~$Loyalty Survey Results EMEA.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file. at Microsoft.Office.Interop.Excel.Workbooks.Open(String Filename, Object UpdateLinks, Object ReadOnly, Object Format, Object Password, Object WriteResPassword, Object IgnoreReadOnlyRecommended, Object Origin, Object Delimiter, Object Editable, Object Notify, Object Converter, Object AddToMru, Object Local, Object CorruptLoad) at ST_71d7b1572b8d440babe9a44ea0da3ab2.vbproj.ScriptMain.Main() End Error Error: 2014-01-23 04:13:51.41 Code: 0x00000008 Source: Refresh Excel FileVbnet Description: The script returned a failure result. End Error DTExec: The package execution returned DTSER_SUCCESS (0). Started: 04:04:00 Finished: 04:13:51 Elapsed: 591.166 seconds. The package executed successfully. The step succeeded.
}

Kindly advise how I get rid of this msg.

Manjula

[Izandol]

It seems one of the workbooks is open and your DTS job is trying to read the lock file. Perhaps you may configure it to ignore files whose names begin with a '~' character?