SSIS Object Model

[paulkeys]

I have an SSIS Package with a data flow (called say df1), containing OLEDB source (called say src) and SQL Server Destination (called say dst).

I'm trying to dynamically assign the table name from the OLEDB source to a variable (say var1) and the table name from the SQL Server destination to another variable (say var2) to enable writing to an audit table

I know that i'll need to use a script task, and access the SSIS object model, but not sure of the syntax to access the two pieces of data.

Can anybody point me in the right direction?

Thanks in advance
Paul

 

[IBACFII]

I did this by using a script task to assign the variable values and then you can choose the variable option from the destination manager in the data flow.