Closed assasafras closed 8 years ago
assasafras
commented
8 years ago Tim thought it might be to do with file size, so we're taken everything but the headers out of the text file \UATAKL016V\CollectionsData\CollectionsDialler\ArrearsLess150dFullListReference.txt.
assasafras
commented
8 years ago Nothing to do with file size.
The package was structured in a way that two jobs would write to the same file at the same time. This caused one of them to arbitrarily fail. The two Data Flow tasks should be pointing to different file paths, not the same.
Correctly setup Flat File Connection Manager "DiallerDataExtract" to write to DiallerArrearsLess150d.txt rather than ArrearsLess150dFullListReference.txt.
Details
Date: 29/09/2016 2:43:26 p.m. Step ID: 9 Server: INTGAKL006V Job Name: Collections - Daily (7am) Step Name: DiallerArrearsLess150d
Message
Executed as user: FLEXIRENT\syssqlint02. Microsoft (R) SQL Server Execute Package Utility Version 10.0.6000.29 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 2:43:26 p.m.
Error: 2016-09-29 14:44:09.10
Code: 0xC020200E
Source: Dialler Data Extract Flat File Destination [120]
Description: Cannot open the datafile "\UATAKL016V\CollectionsData\CollectionsDialler\ArrearsLess150dFullListReference.txt". End Error
Error: 2016-09-29 14:44:09.10
Code: 0xC004701A
Source: Dialler Data Extract SSIS.Pipeline
Description: component "Flat File Destination" (120) failed the pre-execute phase and returned error code 0xC020200E. End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 2:43:26 p.m.
Finished: 2:44:09 p.m.
Elapsed: 43.836 seconds. The package execution failed. The step failed.