Hi, I have build a custom destination adapter with a custom UI. The UI is having few .NET controls like dropdowns and few custom control. After entering the values in UI, whenever I reopen it, all the data is getting lost. I need to re-enter everything even if i want to do a small change. Currently two challenges are there : 1) How to make UI state persistent ? 2) How to transfer data from my component to UI ? I am using custom properties as if now, but since custom proerty also accept only native data type, I am serializing and deserialing it in byte arrary to get the job done. Is there any better approch. Any help would be great. Thanks!!! Prateek

Have a read of http://grounding.co.za/blogs/brett/archive/2007/11/02/developing-a-custom-control-flow-task-for-ssis-part-1.aspx Part 5 - Adding saving and loading of properties to the SSIS package Part 6 - Adding a User interface to edit properties for the custom task Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD

Hi Jeff, Thanks for replying. I wasnt able to make much out of the document. Even if I had the component implement the LoadfromXML and SavetoXML of IDTSpersistent, how will that data get transmitted to my UI? The data anyways get stored in the component, the problem is getting it back to UI. Any help would be great. hanks Prateek

If you read Part 5 of the link I provided, it clearly states that you need to use IDTSComponentPersist.SaveToXML and IDTSComponentPersist.LoadFromXML save/read properties for your component. Please read the article again and do some research on the above mentioned IDTSComponentPersist methods Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD