Hi,
Is there any limits of connect to a single query? I tried to connect up to 100 query components to another query, but during 101 its impossible. Any suggest? Ofcourse I tried to looking for in option tab. Any server options in CMC? I tried everything 
Input: database (over 130 tables)
Output: xml file (wih xsd schema)
saley (BOB member since 2017-12-22)
You coded 100 Query transforms??? That’s a lot of work.
Are all the source tables the same, or do they at the least have the same column name in each table that you’re trying to send to the output?
I have a source system that stored lookup information in 100+ tables that all have identical DDL, just different table names. I wrote a script to create a single query that contained UNION ALL connections. That query is then executed by a SQL transform in a Dataflow. That saved me a ton of time and I no longer have to worry about when the third party developer adds a new lookup table.
eganjp 
(BOB member since 2007-09-12)