Hi Andriy
i am sorry to post my question here,
Its regarding ssis, a flat file integration.. for crm 4.0.
i have done it reffering to the folowing blog,
http://blogs.msdn.com/b/crm/archive/2009/12/31/data-integration-migration-using-sql-integration-services-ssis-2008.aspx
i have successfully created and even updated the existing entity records, but this time.. i was trying to update a related record, eg: accounts has addresses related to it, i wanted to update the "addresses" to the existing "Account records"
in crm 4.0,
but did not work!! the script component which i am using is throwing error!! even after using a try.. catch.. block!! the error is not clear!!
using System;
using System.Data;
using Microsoft.SqlServer.Dts.Pipeline.Wrapper;
using Microsoft.SqlServer.Dts.Runtime.Wrapper;
using SC_df0d701671db41eba60500d15c3c3d65.csproj.crmservice;
[Microsoft.SqlServer.Dts.Pipeline.SSISScriptComponentEntryPointAttribute]
public class ScriptMain : UserComponent
{
CrmService service;
public override void PreExecute()
{
base.PreExecute();
CrmAuthenticationToken token = new CrmAuthenticationToken();
token.AuthenticationType = 0;
token.OrganizationName = "ABBA";
service = new CrmService();
service.Url = "http://localhost:8000/mscrmservices/2007/crmservice.asmx";
service.CrmAuthenticationTokenValue = token;
service.Credentials = System.Net.CredentialCache.DefaultCredentials;
}
public override void PostExecute()
{
base.PostExecute();
/*
Add your code here for postprocessing or remove if not needed
You can set read/write variables here, for example:
Variables.MyIntVar = 100
*/
}
public override void Input0_ProcessInputRow(Input0Buffer Row)
{
try
{
customeraddress cust = new customeraddress();
Lookup lp = new Lookup();
if (!Row.accountid_IsNull)
{
lp.name = Row.name;
lp.Value = new Guid(Row.accountid.ToString());
cust.parentid = lp;<br/> lp.type = "account"; <br/> }
if (!Row.SITENAME_IsNull)
{
cust.name = Row.SITENAME;
}
service.Create(cust);
}
catch (System.Web.Services.Protocols.SoapException e)
{
throw new Exception(string.Format("{0}", e.Detail.InnerText));
}
}
}
the error is "0x80040216 An unexpected error occurred. Platform" even i tried populating / mapping every field in the address entity in the code, it did not work!! please explain me how to go about with this... thanks in advance!!
(prijil.p.s)
ms crm 4.0 - manually, how to insert localization values into the site maps.
