05-22-2012 02:11 PM
I have to add three tables to my user written transformation. But add input/add input is not highlighting.
Can you please anybody help me on this. Thanks in advance.
05-23-2012 12:47 PM
If I remember properly in 3.4 version you cannot add input/output in the transformation,but you can add three user written code transformation for three tables and then append or do a SQL join what ever you want.But for sure in 4.2 version of DI this can done very easily by just doing drag and drop.
eg: table1----> user written code
Table2----->User written code
Table3----->User written code
or in one user written code write you code in properties--->process---->userwritten---->edit and all the code you want to write.
If I am wrong please correct me.
05-25-2012 06:42 AM
If I recall right, the last screen in the Generated Transform wizard, you can specify the minimum and the maximum no of inputs and outputs to the transformation. This should also be available at the properties window of the transformation object (in the inventory/Custom tree).