Hello, I implemented a Data Processing Extension. The SSRS works great but i encountered a behavior i didn't expect. My extension returns 2 different Datasets. both of them are dependent on a prestep process that must finish before they are made, so i thought i will do this prestep in the open() method of my connection implementation. my problem is that i expected the connection instance to be created once, and then for it to get both datasets (in parallel). What is ACTUALLY happening is that the connection instance is being created per dataset so my prestep (which is time and cpu consuming occurs twice). i can of course get around it implement the prestep inside dataset1 and make dataset2 wait for it but then i lose time and flow. Thanks, Harelg

Hi harelg, Thanks for your post. I would suggest you to read the Implementing a Connection Class for a Data Processing Extension carefully, which describe how to implement it and the points need to care. Thanks, Bill LuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.