Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dlorenc
Posting Yak Master
172 Posts |
 Posted - 2009-06-16 : 11:06:18
|
| I am using ssis to move data from an operational system to a datamart (pull only selected fields for the last fiscal year. The schema for the field from the source sql and target sql are identical. the field in the error message, status, is type integer in both source and target tables... I dont understand why ssis is ''truncating" an 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 1SSIS package "CMS_EPMO_MDB Daily PULL v1.dtsx" finished: Success. |
|
|
dlorenc
Posting Yak Master
172 Posts |
Posted - 2009-06-16 : 11:19:29
|
| 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! |
 |
|
|
|
|
|
|
|
ssis text truncation error on an integer field?