var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Insert record into 2 tables using flat file
My DTS reads a flat file uses a Data Driven Query task to select ONLY records that does not exist in the database and then INSERT them to DB1.
This works fine but I need to add another functionality.
I need to create a record on another table(DB2) based on the freshly inserted records in DB1 using only some of the fields.
Event (from 00 to 10)
NumActions (initialized to 0)