I am trying to create table schema based on columns metadata in Script Component.
Its everything fine, but I realized that the metadata columns are incorrect :(. I mean in origin way they should have underscores in names.
SSIS is deleting this marks and unfortunately I have to had original column name instead without underscores. Do You have some explanation ? It might be helpful :P
- This is original source table column names
- This is my connection definition (see there underscores still exists) :
- Script component definition metadata (see there underscores still exists)
- Suddenly underscores disappear:
- Example message box which is showing directly what I want to achieve: