I have a simple package that clears down an SQL database table and then imports data into the table from an external
AS400 database.
The package therefore consists of :-
-A 'SQL Task' to delete all records from my SQL server table.
-A 'On Success' workflow from the 'SQL Task' to an AS400
connection.
-A 'Data Transformation' from the AS400 connection to
an SQL Server connection.
I would like to populate a second table based on
data from the first table without using the AS400 connection. Is this possible? I only want this second tranformation to take place after my first table has been
populated. How can I set a workflow from the completion of the first table transformation to another task that clears down table 2 and then triggers a transformation into table 2 from table 1?
I have tried ading a 'on completion' workflow from the
SQL connection but the table 2 task is not exceuted.
AS400 database.
The package therefore consists of :-
-A 'SQL Task' to delete all records from my SQL server table.
-A 'On Success' workflow from the 'SQL Task' to an AS400
connection.
-A 'Data Transformation' from the AS400 connection to
an SQL Server connection.
I would like to populate a second table based on
data from the first table without using the AS400 connection. Is this possible? I only want this second tranformation to take place after my first table has been
populated. How can I set a workflow from the completion of the first table transformation to another task that clears down table 2 and then triggers a transformation into table 2 from table 1?
I have tried ading a 'on completion' workflow from the
SQL connection but the table 2 task is not exceuted.