June 16, 2009 at 8:56 am
the target table was created with the same schema as the source...the status field in the source and target are type integer, I dont understand why ssis is
''truncating" and integer???
SSIS package "CMS_EPMO_MDB Daily PULL v1.dtsx" starting.
Information: 0x4004300A at DTSTask_DTSDataPumpTask_1 1, DTS.Pipeline: Validation phase is beginning.
Warning: 0x800470C8 at DTSTask_DTSDataPumpTask_1 1, OLE DB Destination [1296]: The external metadata column collection is out of synchronization with the data source columns. The column "Assignee_Login_Name" needs to be updated in the external metadata column collection.
The column "Assignee_Manager_Login" needs to be updated in the external metadata column collection.
The column "Case_ID_" needs to be updated in the external metadata column collection.
The column "Dup_ID_" needs to be updated in the external metadata column collection.
The column "Incident_Reason_Code" needs to be updated in the external metadata column collection.
The column "IncidentID" needs to be updated in the external metadata column collection.
The column "instanceId" needs to be updated in the external metadata column collection.
The column "Last_modified_by" needs to be updated in the external metadata column collection.
The column "Orig_Submitter" needs to be updated in the external metadata column collection.
The column "PDADepartment" needs to be updated in the external metadata column collection.
The column "PDARegion" needs to be updated in the external metadata column collection.
The column "PDASite" needs to be updated in the external metadata column collection.
The column "Phone_Number" needs to be updated in the external metadata column collection.
The column "Prev_Assignee_Login" needs to be updated in the external metadata column collection.
The column "Requested_Completion_Date" needs to be updated in the external metadata column collection.
The column "Requester_ID_" needs to be updated in the external metadata column collection.
The column "Requester_Login_Name_" needs to be updated in the external metadata column collection.
The column "ServiceWareSolutionID" needs to be updated in the external metadata column collection.
The column "Submitted_For" needs to be updated in the external metadata column collection.
The column "Where_Am_I" needs to be updated in the external metadata column collection.
Information: 0x40043006 at DTSTask_DTSDataPumpTask_1 1, DTS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at DTSTask_DTSDataPumpTask_1 1, DTS.Pipeline: Pre-Execute phase is beginning.
Information: 0x4004300C at DTSTask_DTSDataPumpTask_1 1, DTS.Pipeline: Execute phase is beginning.
Error: 0xC020901C at DTSTask_DTSDataPumpTask_1 1, OLE DB Source [1]: There was an error with output column "Status" (32) 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.".
Error: 0xC020902A at DTSTask_DTSDataPumpTask_1 1, OLE DB Source [1]: The "output column "Status" (32)" failed because truncation occurred, and the truncation row disposition on "output column "Status" (32)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
Error: 0xC0047038 at DTSTask_DTSDataPumpTask_1 1, DTS.Pipeline: 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. There may be error messages posted before this with more information about the failure.
Error: 0xC0047021 at DTSTask_DTSDataPumpTask_1 1, DTS.Pipeline: 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: 0xC0047039 at DTSTask_DTSDataPumpTask_1 1, DTS.Pipeline: 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: 0xC0047021 at DTSTask_DTSDataPumpTask_1 1, DTS.Pipeline: 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.
Information: 0x40043008 at DTSTask_DTSDataPumpTask_1 1, DTS.Pipeline: Post Execute phase is beginning.
Information: 0x402090DF at DTSTask_DTSDataPumpTask_1 1, OLE DB Destination [1296]: The final commit for the data insertion has started.
Information: 0x402090E0 at DTSTask_DTSDataPumpTask_1 1, OLE DB Destination [1296]: The final commit for the data insertion has ended.
Information: 0x40043009 at DTSTask_DTSDataPumpTask_1 1, DTS.Pipeline: Cleanup phase is beginning.
Information: 0x4004300B at DTSTask_DTSDataPumpTask_1 1, DTS.Pipeline: "component "OLE DB Destination" (1296)" wrote 0 rows.
Task failed: DTSTask_DTSDataPumpTask_1 1
SSIS package "CMS_EPMO_MDB Daily PULL v1.dtsx" finished: Success.
June 16, 2009 at 9:21 am
found it!...strange...in looking into the metadata update message (thinking they might be related), I used the 'Show Advanced Editor' on the ole db source (data flow source), icon...
looking thru the tabs (connection managers, component properties, column mappings, input and output properties); in input and output properties I check ed the 'OLE DB Source Output' item, expanded it to External Columns and Output Columns...
expanded to show the external columns and verified that the field 'Status' had a datatype property of four-byte signed integer..(so far..so good)..
but checking the Output Columns, expanding them, clicking on status, I found it was a varchar datatype...(even tho the target table, Status is INT...??)...
the solution was to edit the DataType for Output Column Status, changing it to a four-byte signed integer...
then going back to the control flow for this Data Flow Task, and just doing an execute task (right click)...it ran just fine..(still get the meta data warnings...but that doesnt seem to matter...)..
weeeeeeeeeeee!
June 16, 2009 at 9:31 am
Great and thanks for posting what you found.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 1, 2010 at 4:01 am
Wonderful... You saved me few hours of work and thanks a lot for your solution.
Logan
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply