March 21, 2016 at 8:32 am
The job which runs the SSIS packages failed with the error message below.
But the same package when I ran from visual studio ran successfully
Description: Data conversion failed.
The data conversion for column "Column 6" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
End Error Error: 2016-03-21 09:17:13.91
Code: 0xC020902A Source: File Source - CSVsource_csv [1]
Description: The "output column "Column 6" (34)" failed because truncation occurred, and the truncation row disposition on "output column "Column 6" (34)"
specifies failure on truncation. A truncation error occurred on the specified object of the specified component. End Error Error: 2016-03-21 09:17:13.92 Code: 0xC0202092 Source: Import CSV File Source - CSVsource_csv [1] Description: An error occurred while processing file "\\D\E$\a.csv" on data row 96. End Error Error: 2016-03-21 09:17:13.92 Code: 0xC0047038 Source: Import CSV File SSIS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Source - CSVsource_csv" (1) returned error code 0xC0202092. 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 DTExec: The package execution returned DTSER_FAILURE (1). Started: 9:17:12 AM Finished: 9:17:13 AM Elapsed: 1.7 seconds. The package execution failed. The step failed.[/highlight]
March 21, 2016 at 1:10 pm
Just wondering if you've got some NVARCHAR data that is a problem because of the data length, or perhaps there's data in production that's not in your testing instance?
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 21, 2016 at 1:28 pm
Try running the package in 32/64 bit in VS.
March 23, 2016 at 9:55 am
SSIS package runs from when I execute it manually or from VS. But it fails from the agent with the truncation error.
What could be the issue?
March 23, 2016 at 9:52 pm
PJ_SQL (3/23/2016)
SSIS package runs from when I execute it manually or from VS. But it fails from the agent with the truncation error.What could be the issue?
You didn't say whether the package is in 32-bit or 64-bit mode, nor did you address whether or not the possible presence of differing data on the server, nor have you provided any detail whatsoever about what this package does, and having ignored the previous replies, you still want help? Seriously?
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply