July 16, 2009 at 4:52 am
Hi all,
In My Scenario.
I have source table having data types numeric varchar and text
when i read data from the source table with ssis using single query it does not give error. But when give multiple query on single source table and take that resluts to target table. Then i get the following error on production server
Message
Executed as user: NTHODOMAIN\ho1dbc10_dbadmin. Microsoft (R) SQL Server Execute Package Utility Version 10.0.1600.22 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:05:12 AM Error: 2009-05-16 00:06:02.91 Code: 0xC0047070 Source: DFT RCE_EXPDICRATING_DF DICRating_ID>160000 and DICRating_ID<225000 Description: End Error Error: 2009-05-16 00:06:02.94 Code: 0x80004005 Source: DFT RCE_EXPDICRATING_DF DICRating_ID>160000 and DICRating_ID<225000 Description: End Error Error: 2009-05-16 00:06:02.95 Code: 0xC0208266 Source: DFT RCE_EXPDICRATING_DF DICRating_ID>160000 and DICRating_ID<225000 Description: End Error Error: 2009-05-16 00:06:02.97 Code: 0xC0208265 Source: DFT RCE_EXPDICRATING_DF DICRating_ID>160000 and DICRating_ID<225000 OLE_SRC EXPDICRATING [1] Description: Failed to retrieve long data for column "XMLText". End Error Error: 2009-05-16 00:06:02.97 Code: 0xC020901C Source: DFT RCE_EXPDICRATING_DF DICRating_ID>160000 and DICRating_ID<225000 OLE_SRC EXPDICRATING [1] Description: There was an error with output column "XMLText" (98) on output "OLE DB Source Output" (11). The column status returned was: "DBSTATUS_UNAVAILABLE". End Error Error: 2009-05-16 00:06:02.97 Code: 0xC0209029 Source: DFT RCE_EXPDICRATING_DF DICRating_ID>160000 and DICRating_ID<225000 OLE_SRC EXPDICRATING [1] Description: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "output column "XMLText" (98)" failed because error code 0xC0209071 occurred, and the error row disposition on "output column "XMLText" (98)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. End Error Error: 2009-05-16 00:06:02.98 Code: 0xC0047038 Source: DFT RCE_EXPDICRATING_DF DICRating_ID>160000 and DICRating_ID<225000 SSIS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE_SRC EXPDICRATING" (1) returned error code 0xC0209029. 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: 12:05:12 AM Finished: 12:45:42 AM Elapsed: 2428.88 seconds. The package execution failed. The step failed.
column involved here in source table has text data type where as in target it has varchar(max). does it make the difference.
Please suggest
Regards
ramu
July 17, 2009 at 1:03 am
guys i hope my problem is clear to u all
Regards
Ramu
July 17, 2009 at 2:43 am
are u trying to use multiple queries in the different dataflows under the same task?
July 17, 2009 at 3:00 am
Hi I'm Ramu's friend and we are working on same issue
Actually our source table contains 4lac records and it contains xmls.
While fetching data from source and loading to target takes lot time.
That's why we splite the data across into 5 data flow tasks (DFT).
Does it creates any issue!!! If it so then how to handle?
Thanks
Ram
July 17, 2009 at 4:26 am
hussain27syed (7/17/2009)
are u trying to use multiple queries in the different dataflows under the same task?
Yes i am doing the same way.
July 20, 2009 at 4:40 am
Please help guys.
ramuvanparti (7/17/2009)
hussain27syed (7/17/2009)
are u trying to use multiple queries in the different dataflows under the same task?Yes i am doing the same way.
July 20, 2009 at 6:43 am
ramu,
If you are using multiple data flows in the same task, then clearly one of the data flows has failed which has caused the others to fail.
you need to test each data flow individually to check which data flow is causing this.
Alternatively you can run all the data flows and see which fails first, then run it individually to see why it failed.
July 21, 2009 at 3:41 am
To be more specific, i have source table lets mytable which have 4 million records.
in order to reduce the time i have taken four dataflow. and in each data flow in the source oledb have filtered the rows on particular range repectively differ condition in all other data flows. purpose was to insert the data from single source in parallel to target table.
I have doubt on text data type column Is this cannot function in parallel mode when i used single dataflow i didnt get any error. More over text column is insert into varchar column with max option. Is it making problem. as it uses blob for temporary storage.
hussain27syed (7/20/2009)
ramu,If you are using multiple data flows in the same task, then clearly one of the data flows has failed which has caused the others to fail.
you need to test each data flow individually to check which data flow is causing this.
Alternatively you can run all the data flows and see which fails first, then run it individually to see why it failed.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply