hi i want to check data exist in crm & check with sql database in ssis script component with web services when i check data exist in crm & retrive it from crm i want to check if id which i have retrived is n ot null how to do this? I am using CRM 4.0 & SSIS 2005 please Help its urgent

Hi, I think that you miss some information like from where come the data and what want to do. What does the code inside Script Component, call web service? Also can evaluate the null value in it and fill any column with this information. CRM, is the source or the webservice provider? Please, give us some more information to help better. Regards. Vctor M. Snchez Garca (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it. http://bifase.blogspot.com | http://twitter.com/atharky

hi i want to check data exist in crm & check with sql database in ssis script component with web services when i check data exist in crm & retrive it from crm i want to check if id which i have retrived is n ot null how to do this? I am using CRM 4.0 & SSIS 2005 please Help its urgent Using CRM API is complex task and this is not the appropriate place for these questions. I would recommend you post your questions here . If you can use third-party solutions, check the commercial CozyRoc CRM integration adapters: Dynamics CRM Source SSIS Data Flow Component Dynamics CRM Destination SSIS Data Flow Component Dynamics CRM SSIS Connection Manager All CRM deployment types are supported: Premise, Live, Hosted. These adapters simplify your Dynamics CRM integrations considerably.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

see basically i want to fetch specific coulmn data from crm & in script component i am using crmwebservices to fetch data from crm so first if u can help this then its good for me Thanks for your reply