August 13, 2009 at 6:34 am
I am having a date column in my SQL DB.I have to load the data in Excel sheet using SSIS.I did data conversion.
In OLE DB Source, the error turns red sayin:
[OLE DB Source [1]] Error: There was an error with output column "TS POSTED DT" (184) on output "OLE DB Source Output" (11). The column status returned was: "Text was truncated or one or more characters had no match in the target code page.".
[OLE DB Source [1]] Error: The "output column "TS POSTED DT" (184)" failed because truncation occurred, and the truncation row disposition on "output column "TS POSTED DT" (184)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source" (1) returned error code 0xC020902A. 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.
Kindly help as to what should be done.I have an OLE DB Source,then a data Conversion then a excel destination.For some Date Fields it works fine but for others its throwing an error as above though both the fields are of same type.Highly critical!!!!
August 14, 2009 at 6:38 am
Can you post some sample data? Particularly a row that causes the error?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 14, 2009 at 6:43 am
Hi,I sorted that out...now a new bug....
Actually i am protecting the destn excel sheet using Protect Sheet option to lock one row which contains sensitive info not to be know to client..other columns which has to be loaded with data is unlocked...
Now if i keep the excel open and then run ssis, data gets inserted perfectly...but if its is closed this error: User does not have permission pops up...pls help....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply