question

Gehima2016 avatar image
Gehima2016 asked

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."
ssiserror-message
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question reverted to original form so we can see what the error message was and the answers make sense.
0 Likes 0 ·
mdawini avatar image
mdawini answered
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.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Gehima2016 avatar image
Gehima2016 answered
Hi mdawini, Thank you for your response. I will check on the consistencies of the destination table structure. I appreciate you.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.