<pre lang="sql">
USE <pre lang="sql">HRMS0
Create Table Employee_details_test (employee_id varchar(100),Name varchar(100),Designation_code varchar(200))
insert into Employee_details_test values (&#39;B0001&#39;,&#39;Ramesh.G&#39;,&#39;J0001&#39;),
(&#39;B0002&#39;,&#39;Suresh&#39;,&#39;J0001&#39;),(&#39;B0003&#39;,&#39;Ram.G&#39;,&#39;J0002&#39;),(&#39;B0004&#39;,&#39;Biju&#39;,&#39;J0005&#39;)</pre></pre>
use PER1
Create Table Employee_details_test1 (employee_id varchar(100),Name varchar(100),Designation_code varchar(200))
insert into Employee_details_test1 values ('B0001','Ramesh.G','J0002'),
('B0002','Sures.m','J0001'),('B0003','Ram.G','J0002'),('B000','Biju','J0005')
Now i need a shedular to be RUN in SSIS package to update wat eever Changes happen in Hrms 40 table reflect in perdb table
Example if i do Changes name for B0001 as Ramesh.M in HRMS40 DB , the shedular should automatically do Changes PER1 table Employee_details_test1 against B0001 as Ramesh.M