x

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."

more ▼

asked Apr 28 at 03:48 PM in Default

avatar image

Gehima2016
1 1

question reverted to original form so we can see what the error message was and the answers make sense.

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.

more ▼

answered Apr 29 at 11:02 AM

avatar image

mdawini
81 1 4

(comments are locked)
10|1200 characters needed characters left

Hi mdawini,

Thank you for your response. I will check on the consistencies of the destination table structure. I appreciate you.

more ▼

answered Apr 29 at 02:26 PM

avatar image

Gehima2016
1 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1219
x89

asked: Apr 28 at 03:48 PM

Seen: 95 times

Last Updated: 6 days ago

Copyright 2017 Redgate Software. Privacy Policy