User is trying for bulk update the tags and the job is getting stuck in SMC.
1. Error -1071636471 in Load Dynamic Tag Sheets - Data Flow Task/Char Data - OLE DB Destination : SSIS Error Code DTS_E_OLEDBERROR
2. Error -xxxxxxxxxxx in Tag to Document Relationship
3. Error -xxxxxxxxxxx in Add Responsibilities
4. Error -xxxxxxxxxxx in Tag to Tag Reationship
SSIS package fails to load the sheet if some thing is wrong with the excel like excel is corrupted, Summary sheet is not able take the reference fr the Tags.
Sometimes Error 1 occurs due to user mistakes, there are some documents which are provided to the user to avoid mistakes(Attaching the Pdf files)
0508.Asset Tag Excel Update Rev 01.pdf