Problems in SQL Server 2005 that do not create a new role (JOB)

1. When you create a job using sqlserver2005, you cannot create a prompt

An object of type ' Microsoft.SqlServer.Management.Smo.SimpleObjectKey cannot be cast to type '   Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey ". (MICROSOFT.SQLSERVER.SMO)

Query a lot of online information, most of the need to go to Microsoft Official network download a SP2 plug-in, open the link is: Microsoft SQL Server 2005 Service Pack 2, according to the corresponding system version choose 64-bit or 32-bit installation, But I system is a 64-bit installation time encountered a situation, after installation still failed, try to use 32 bit success, the current reason has not found, if any big God know, please leave a message to tell a voice!

2. Regarding the use of the job to do data synchronization, if the table data to be copied contains the primary key, the first time the job runs normally, the second run of the job when the SSIS package primary key conflict, the solution can be used to clear the data after the copy event, or subscribe to the way you can!

Problems in SQL Server 2005 that do not create a new role (JOB)