can someone help me with this error!!!!plzz Beforre I can union all,I Converted them to But,this error occurs while conversion SSIS package "SSISRunTimeMetrics.dtsx" starting. Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning. Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning. Warning: 0x80049304 at Data Flow Task, SSIS.Pipeline: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console. Information: 0x40043006 at Data Flow Task, SSIS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Flow Task, SSIS.Pipeline: Pre-Execute phase is beginning. Information: 0x4004300C at Data Flow Task, SSIS.Pipeline: Execute phase is beginning. Information: 0x402090DF at Data Flow Task, ISB MS ERROR TABLE [1697]: The final commit for the data insertion in "component "ISB MS ERROR TABLE" (1697)" has started. Information: 0x402090E0 at Data Flow Task, ISB MS ERROR TABLE [1697]: The final commit for the data insertion in "component "ISB MS ERROR TABLE" (1697)" has ended. Error: 0xC0202009 at Data Flow Task, ERROR [3822]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Invalid character value for cast specification". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Invalid character value for cast specification". Error: 0xC02020C5 at Data Flow Task, Lahore Data Conversion [3302]: Data conversion failed while converting column "St_Name" (2604) to column "FName3" (3418). The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.". Error: 0xC02020C5 at Data Flow Task, Islamabad Data Conversion [3763]: Data conversion failed while converting column "Name" (2262) to column "FName2" (3773). The conversion returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". Error: 0xC020901C at Data Flow Task, ERROR [3822]: There was an error with input column "Date of Birth" (3856) on input "OLE DB Destination Input" (3835). The column status returned was: "The value could not be converted because of a potential loss of data.". Error: 0xC0209029 at Data Flow Task, Lahore Data Conversion [3302]: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "output column "FName3" (3418)" failed because error code 0xC020907F occurred, and the error row disposition on "output column "FName3" (3418)" 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. Error: 0xC020902A at Data Flow Task, Islamabad Data Conversion [3763]: The "output column "FName2" (3773)" failed because truncation occurred, and the truncation row disposition on "output column "FName2" (3773)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. Information: 0x402090DF at Data Flow Task, ISB BS ERROR [2541]: The final commit for the data insertion in "component "ISB BS ERROR" (2541)" has started. Error: 0xC0209029 at Data Flow Task, ERROR [3822]: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "OLE DB Destination Input" (3835)" failed because error code 0xC0209077 occurred, and the error row disposition on "input "OLE DB Destination Input" (3835)" 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. Error: 0xC0047022 at Data Flow Task, SSIS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Lahore Data Conversion" (3302) failed with error code 0xC0209029 while processing input "Data Conversion Input" (3303). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. Error: 0xC0047022 at Data Flow Task, SSIS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Islamabad Data Conversion" (3763) failed with error code 0xC020902A while processing input "Data Conversion Input" (3764). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. Information: 0x402090E0 at Data Flow Task, ISB BS ERROR [2541]: The final commit for the data insertion in "component "ISB BS ERROR" (2541)" has ended. Error: 0xC0047022 at Data Flow Task, SSIS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "ERROR" (3822) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (3835). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. Error: 0xC02020C4 at Data Flow Task, KARACHI STUDENTS [1]: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020. Error: 0xC0047038 at Data Flow Task, SSIS.Pipeline: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "KARACHI STUDENTS" (1) returned error code 0xC02020C4. 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: 0xC02020C5 at Data Flow Task, Karachi Data Conversion [3614]: Data conversion failed while converting column "Father" (23) to column "LName1" (3627). The conversion returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". Error: 0xC020902A at Data Flow Task, Karachi Data Conversion [3614]: The "output column "LName1" (3627)" failed because truncation occurred, and the truncation row disposition on "output column "LName1" (3627)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. Error: 0xC0047022 at Data Flow Task, SSIS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Karachi Data Conversion" (3614) failed with error code 0xC020902A while processing input "Data Conversion Input" (3615). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. Information: 0x40043008 at Data Flow Task, SSIS.Pipeline: Post Execute phase is beginning. Information: 0x402090DF at Data Flow Task, KCH ERROR TABLE [219]: The final commit for the data insertion in "component "KCH ERROR TABLE" (219)" has started. Information: 0x402090E0 at Data Flow Task, KCH ERROR TABLE [219]: The final commit for the data insertion in "component "KCH ERROR TABLE" (219)" has ended. Information: 0x402090DF at Data Flow Task, ERROR [3822]: The final commit for the data insertion in "component "ERROR" (3822)" has started. Information: 0x402090E0 at Data Flow Task, ERROR [3822]: The final commit for the data insertion in "component "ERROR" (3822)" has ended. Information: 0x402090DF at Data Flow Task, OLE DB Destination [4259]: The final commit for the data insertion in "component "OLE DB Destination" (4259)" has started. Information: 0x402090E0 at Data Flow Task, OLE DB Destination [4259]: The final commit for the data insertion in "component "OLE DB Destination" (4259)" has ended. Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "component "KCH ERROR TABLE" (219)" wrote 0 rows. Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "component "ISB MS ERROR TABLE" (1697)" wrote 0 rows. Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "component "ISB BS ERROR" (2541)" wrote 0 rows. Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "component "ERROR" (3822)" wrote 0 rows. Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "component "OLE DB Destination" (4259)" wrote 0 rows. Information: 0x40043009 at Data Flow Task, SSIS.Pipeline: Cleanup phase is beginning. Task failed: Data Flow Task Warning: 0x80019002 at "ETL BASICS": SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (15) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. Warning: 0x80019002 at SSISRunTimeMetrics: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (15) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. SSIS package "SSISRunTimeMetrics.dtsx" finished: Failure. The program '[2208] SSISRunTimeMetrics.dtsx: DTS' has exited with code 0 (0x0).mhassanshahbaz

There seems to be a security issue, do you run BIDS as admin (right-click on the BIDS icon and choose run as Admin)?Arthur My Blog

1. Check if the data type of the source data rows matches the destination. eg RegistrationNo if the destination data type is int and your data has a string value (234n) 2. There is a truncation in Fname2 destination :check if the length of the data in any of the rows exceeds the destination length 3. Carry out a data conversion to convert all DT_WSTR to DT_STR Hope this helps. Regards, Sandeep

"Invalid character value for cast specification" what is your source datatype and destination datatype? seems that you have inappropriate characters in your column values, for example if you convert 12rf333 to DT_I4 you will get error.http://www.rad.pasfu.com

everything is work fine now,i have converted all to DT_WSTR in data conversion,then took union all and send it to data warehouse.Thanks everyone. Is DT_WSTR is better or I should change it to DT_STR before loading into DWH,suggest plzmhassanshahbaz

using DT_WSTR or DT_STR is based on your data , DT_STR A null-terminated ANSI/MBCS character string with a maximum length of 8000 characters. (If a column value contains additional null terminators, the string will be truncated at the occurrence of the first null.) DT_WSTR A null-terminated Unicode character string with a maximum length of 4000 characters. (If a column value contains additional null terminators, the string will be truncated at the occurrence of the first null.) reference: http://msdn.microsoft.com/en-us/library/ms141036.aspx http://www.rad.pasfu.com

AFTER TRANSFORMATION,18,003 are being loaded to DWH i used data viewer it showed 7801 rows first time when buffer=1,second time it showed 15,602 and last time 18,003. my question is why it`s not showing all rows at a time???? important:- 2)*IN ssms when i checked SELECT * FROM [Students_ info] its only showing 7801 rows...why not showing renaming ones????mhassanshahbaz

I can't understand what you mean exactly. but this seems that this is another issue, could you create new question and put your problem there With more explanation of what you trying to do. http://www.rad.pasfu.com

actually In SSIS, 18,003 rows are loaded to Student_info.But in sql server management studio,it`s showing only 7801 rows...mhassanshahbaz

hmmm it resolved, column length of destination table was not accepting higher length valuesmhassanshahbaz

actually In SSIS, 18,003 rows are loaded to Student_info.But in sql server management studio,it`s showing only 7801 rows... mhassanshahbaz did you got any error? did you set CONFIGURE ERROR OUTPUT on destination to ignore ? are you sure that you check same table in same database in SSMS? maybe you load data in one database but you check in ssms another database.http://www.rad.pasfu.com

its resolveed now i have this problem..., i want to check those rows which have department and date of birth NULL [M/F] != "M" && [M/F] != "F" || Department == " " || [Date of Birth] == " " TITLE: Microsoft Visual Studio ------------------------------ Error at Data Flow Task [KCH Gender Conditional Split [688]]: The data types "DT_DBTIMESTAMP" and "DT_WSTR" are incompatible for binary operator "==". The operand types could not be implicitly cast into compatible types for the operation. To perform this operation, one or both operands need to be explicitly cast with a cast operator. Error at Data Flow Task [KCH Gender Conditional Split [688]]: Attempt to set the result type of binary operation "DoB == " "" failed with error code 0xC0047080. Error at Data Flow Task [KCH Gender Conditional Split [688]]: Computing the expression "[M/F] != "M" && [M/F] != "F" || [Department] == " " || [DoB] ==" "" failed with error code 0xC0047084. The expression may have errors, such as divide by zero, that cannot be detected at parse time, or there may be an out-of-memory error. Error at Data Flow Task [KCH Gender Conditional Split [688]]: The expression "[M/F] != "M" && [M/F] != "F" || [Department] == " " || [DoB] ==" "" on "output "Error" (710)" is not valid. Error at Data Flow Task [KCH Gender Conditional Split [688]]: Failed to set property "Expression" on "output "Error" (710)". ------------------------------ ADDITIONAL INFORMATION: Exception from HRESULT: 0xC0204006 (Microsoft.SqlServer.DTSPipelineWrap) ------------------------------ BUTTONS: OK ------------------------------mhassanshahbaz

what is datatype of columns above? maybe you have numeric columns and you want to check it with string . http://www.rad.pasfu.com