Thanks

sp_columns did the trick

Got my answer forgot to turn on the write to repository checkbox

Can you explain what your exactly doing?

Are you passing the correct variable to the lookup?

Are you adding the keys to right table?

Thanks NProatt. That was a good idea.

I think this is more on the basis of SQL Statements. Its not really DTS.

I want to capture a structure change of a table in another table. Like an...

Thanks for the info, I'll give it a try