Share
Report
550Hi ,
I have to update a filed territory in contact form from Account territory field using inner join in SSIS import method for all records.
After update there are more than 5000+ records that is not updated . but there is no error when i redirect the columns for errors...
It has run successfully, but at the end there are some columns that had not been updated... i did not understand the problem ..
I am running this in production environment . I already ran the same in development environment and did not face any problem..
Getting the following warning :
0x80049304 at Data Flow Task, SSIS.Pipeline: Warning: The shared global memory could not be opened to communicate with the performance DLL; There are no data flow counters available. Run this package as an administrator or on the system console to correct the problem.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The CrmRecordId output column (1519) in the Default Output (1518) output and the Dynamics CRM Destination component (797) is not used in the data flow task. Removing this unused output column can optimize the performance of the data flow task.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The IsNew output column (1520) in the Default Output (1518) output and the Dynamics CRM Destination component (797) is not used in the data flow task. Removing this unused output column can optimize the performance of the data flow task.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The crm1st_territory output column (1569) in the output merge join output (1568) and merge join (1556) component is not used in the data flow task. Removing this unused output column can optimize the performance of the data flow task.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The parentcustomerid output column (1573) in the "Merge Joining Output" output (1568) and the "merge join" component (1556) is not used in the data flow task. Removing this unused output column can optimize the performance of the data flow task.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The accountid output column (1575) in the "Merge Joining Output" output (1568) and the "merge join" component (1556) is not used in the data flow task. Removing this unused output column can optimize the performance of the data flow task.
Information: 0x40043006 at Data Flow Task, SSIS.Pipeline: The Prepare Execution phase begins.
Thanks
Hajira
*This post is locked for comments
I have the same question (0)
All responses (
Answers (
