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

  1. This is original source table column names

enter image description here

  1. This is my connection definition (see there underscores still exists) :

enter image description here

  1. Script component definition metadata (see there underscores still exists)

enter image description here

  1. Suddenly underscores disappear:

enter image description here

  1. Example message box which is showing directly what I want to achieve:

enter image description here

1 Answers

0
Hadi On

I don't think it is a good choice to generate a Create Table statement based on Script Component Columns metadata since all symbols are removed from Columns names (not only underscore). You can simply use an SQL Statement to do that:

To implement this solution in SSIS, use an Execute SQL Task and store the result within a ResultSet: