How to execute SSIS Packate (SQL Agent) with Turbo Integrator

1.- Create SQL Job in SQL Agent that contains the SQL Packate that you want to execute.

2.- Create Storage Procedure that execute the previus SQL Job.

3.- Create TI process to execute previus Storage Procedure

SQL Server - Transact-SQL

1. MODIFY Column Data Type

ALTER TABLE <table name> ALTER COLUMN <Column Name> <New Data Type> <allow null>;

ALTER TABLE TB_EXAM ALTER COLUMN INTEREST_RATE Float null;

2. ADD Column Data Type

ALTER TABLE <table name> ADD <Column Name> <New Data Type> <allow null>;

ALTER TABLE TB_EXAM2 ADD INTEREST_RATE Numeric(18,3) not null;