SSIS PACKAGE ERROR
Hi, Our SSIS package used for bulk insert failed with error below. But the job succeeded the previous day since the job have been set up for a while now. Can anyone give a clue as to what the problem is. "Message Executed as user: A70TUCGSMSQL003\SVC_SQLAGENTUSER. Microsoft (R) SQL Server Execute Package Utility Version 10.50.6000.34 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 8:20:07 AM Error: 2017-04-28 08:20:09.15 Code: 0xC002F304 Source: Insert Claims U Bulk Insert Task Description: An error occurred with the following error message: "Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.Bulk load: An unexpected end of file was encountered in the data file.". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:20:07 AM Finished: 8:20:12 AM Elapsed: 4.172 seconds. The package execution failed. The step failed."
question reverted to original form so we can see what the error message was and the answers make sense.
Hi mdawini, Thank you for your response. I will check on the consistencies of the destination table structure. I appreciate you.
Check your file and make sure there isn't anything amiss This "An unexpected end of file was encountered in the data file." sound as if your file is corrupt or maybe the columns have changed or something. So as a starting point I will look at the file you are trying to upload and check if anything has changed.
