How do I share a database connection with sub jobs?
Hi
I want to use a connection in a master job that will be used by all of the sub jobs. In the connection component in the main job I have checked the "Use or register a shared DB connection" and entered a name "Master".
I have added a connection component to a sub job and done the same thing. The database output component uses existing connection and refers to the connection component on the sub job. (See screen shots)
The job runs OK but no data is present in the database. I don?t think I have set up the shared connection correctly.
Any help gratefully received.