<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Data Corruption
»
ssis truncation error, dataflow task, sql to...
ssis truncation error, dataflow task, sql to sql
Rate Topic
Display Mode
Topic Options
Author
Message
dan.lorenc
dan.lorenc
Posted Tuesday, June 16, 2009 8:56 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, August 20, 2009 2:31 PM
Points: 3,
Visits: 12
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.
Post #735740
dan.lorenc
dan.lorenc
Posted Tuesday, June 16, 2009 9:21 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, August 20, 2009 2:31 PM
Points: 3,
Visits: 12
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!
Post #735773
Alvin Ramard
Alvin Ramard
Posted Tuesday, June 16, 2009 9:31 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 9:37 AM
Points: 1,147,
Visits: 3,408
Great and thanks for posting what you found.
-- Alvin Ramard
Post #735779
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
