SSIS PROBLEM

• yogi123

  SSCrazy

  Points: 2774

  More actions

  July 31, 2012 at 9:41 am

  #278765

  Hello friends

  I have schedule jobs every day to export data into flat file. but today its failed and here is error message

  Executed as user: XXXXX. ...00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:23:27 AM Error: 2012-07-31 11:24:51.09 Code: 0xC0202053 Source: AppendixA AppendA [1346] Description: Cannot write to the data file. End Error Error: 2012-07-31 11:24:51.09 Code: 0xC02020A0 Source: AppendixA AppendA [1346] Description: Cannot copy or convert flat file data for column "folderSchoolDate". End Error Error: 2012-07-31 11:24:51.09 Code: 0xC0047022 Source: AppendixA Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "AppendA" (1346) failed with error code 0xC02020A0. 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 package execution fa... The step failed.

  Please help me to resolve this.

  Thanks

• demonfox

  SSCertifiable

  Points: 6289

  More actions

  July 31, 2012 at 10:24 am

  #1519836

  turn on the package logging to have a better picture..

  it says conversion error; may be the data for column "folderSchoolDate" have special characters that require unicode settings to be set..

  ~ demonfox
  ___________________________________________________________________
  Wondering what I would do next , when I am done with this one :ermm: