Cannot copy or convert flat file data for column

Question

I am facing issue with ssis package while converting Datetime field from oledb source to flatfile file. this i am not facing every time its happening some times. please help me on this. i have data type for DB_Timestamp for the column in destination DT_STR (50).

Executed as user: NA\X16871. Microsoft (R) SQL Server Execute Package Utility Version 12.0.5000.0 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 3:30:08 PM Error: 2017-11-16 16:40:37.45 Code: 0xC0202053 Source: DFT - Error Reports FF DST Load Error Report [2] Description: Cannot write to the data file. End Error Error: 2017-11-16 16:40:37.45 Code: 0xC02020A0 Source: DFT - Error Reports FF DST Load Error Report [2] Description: Cannot copy or convert flat file data for column "OPEN_SINCE". End Error Error: 2017-11-16 16:40:37.45 Code: 0xC0047022 Source: DFT - Error Reports SSIS.Pipeline Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "FF DST Load Error Report" (2) failed with error code 0xC02020A0 while processing input "Flat File Destination Input" (6). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. End Error Error: 2017-11-16 16:40:43.48 Code: 0xC0209017 Source: DFT - Error Reports OLE DB Source [35] Description: Setting the end of rowset for the buffer failed with error code 0xC0047020. End Error Error: 2017-11-16 16:40:43.48 Code: 0xC0047038 Source: DFT - Error Reports SSIS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on OLE DB Source returned error code 0xC0209017. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. End Error Error: 2017-11-16 16:40:43.48 Code: 0xC0202053 Source: DFT - Error Reports FF DST Load Error Report [2] Description: Cannot write to the data file. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 3:30:08 PM Finished: 4:40:43 PM Elapsed: 4234.5 seconds. The package execution failed. The step failed.

Answer 1

Yes, It is a Data conversion issue, Your flat file has DT_STR but your source field has the Type DT_DBTIMESTAMP. you should either convert your source or your destination field so that both have the same Datatype. Although I'm not sure how the package was running prior to this if there were not changes made while debugging.

Answer 2

Conversion error occurs sometimes, I would rather look at source component. Right click on OLEDB source and click on Advance editor and look for Input/Output properties. Expand Output columns and check for data type. Change it to db_timestamp, sometimes it fails and succeeds if data type is dt_str.