Fantastic, thank you so much! Can I ask you another thing please? It's related with output table steps.
I have one fact table and tables around it which are dimensions. The relation is I-N.
From Merger Join step I add Table output step, I select the table that I want to create ( the first one is fact table) in "target table" section. But in SQL buttom appears "Alter TABLE name of fact table modify name of each column", and I don´t think the systemas has to modify anything...
Furthermore, when I run everything, the final errors of this step is "Error batch inserting rows into table [name of fact table]" and the second error is "Unknown colum "primary key_1".
*This primary key_1 comes from when I merge Excel 1 with Excel 2, an the result of this union is primary_key, columns of first Excel, primary_key1, columns from second Excel.
I hope I explain myself clear, and thank you!!