Auto create "output" under transformation?

More
8 years 11 months ago - 8 years 11 months ago #11684 by orlandoc
Greetings,

I have a file to read - it is a piped delimited file. But I have to read the total number of width per line as part of validation.
So I use the splitter after my validation. The Splitter will do the split based on piped delimited. The total number of fields are 138. The tedious part is to drag the "Output" connection node under Transformation and 138 of them. The Automap can produce the number of output but not mapping them. - see screen shot.
Is there a way or technique to generate number of "Output" based on the source number of fields? And then it is easy to manipulate after that. Please advise.

Thank you.
Attachments:
Last edit: 8 years 11 months ago by orlandoc.

Please Log in or Create an account to join the conversation.

More
8 years 11 months ago #11687 by admin
If I was you I would create 2 transformations one to validate
data another to transform and run it from the package.

Mike

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
8 years 11 months ago #11688 by admin
If I was you I would create 2 transformations one to validate
data another to transform and run it from the package.

Mike

Mike
ETL Architect
The following user(s) said Thank You: orlandoc

Please Log in or Create an account to join the conversation.