Unicode with more that 4000 in length

• manjah

  Valued Member

  Points: 68

  More actions

  September 11, 2009 at 10:52 am

  #138008

  I am trying to export data to a flat file with fix length. The vendor required length is 4095 and it should be unicode. The process present runs fine as a standalone SSIS package. I am trying to implement this process into a dynamic package that is driven by SQL tables and stored procedures. I am having problem because DT_WSTR max length is 4000. I changed it to DT_NTEXT as well using nvarchar(max) and getting the following the error messages:

  [OLE DB Source [803]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".

  [OLE DB Source [803]] Error: Failed to retrieve long data for column "OutputRow".

  [OLE DB Source [803]] Error: There was an error with output column "OutputRow" (1264) on output "OLE DB Source Output" (813). The column status returned was: "DBSTATUS_UNAVAILABLE".

  [OLE DB Source [803]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "output column "OutputRow" (1264)" failed because error code 0xC0209071 occurred, and the error row disposition on "output column "OutputRow" (1264)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.

  Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source" (803) returned error code 0xC0209029. 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.

  Error: SSIS Error Code DTS_E_THREADFAILED. Thread "SourceThread0" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited.

  Error: SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error messages posted before this with more information on why the thread was cancelled.

  Error: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0047039. There may be error messages posted before this with more information on why the thread has exited.