TITLE: Package Validation Error ------------------------------ Package Validation Error ------------------------------ ADDITIONAL INFORMATION: Error at Data Flow Task [Script Component [28]]: Microsoft.SqlServer.Dts.Pipeline.CannotCreateUserComponentException: Cannot create user component class. Make sure there is one class marked with SSISScriptComponentEntryPointAttribute in your script. at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.CreateUserScriptInstance() Error at Data Flow Task [Script Component [28]]: Microsoft.SqlServer.Dts.Pipeline.CannotCreateUserComponentException: Cannot create user component class. Make sure there is one class marked with SSISScriptComponentEntryPointAttribute in your script. at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.CreateUserScriptInstance() Error at Data Flow Task [Script Component [28]]: The binary code for the script is not found. Please open the script in the designer by clicking Edit Script button and make sure it builds successfully. Error at Data Flow Task [SSIS.Pipeline]: "component "Script Component" (28)" failed validation and returned validation status "VS_ISBROKEN". Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation. Error at Data Flow Task: There were errors during task validation. (Microsoft.DataTransformationServices.VsIntegration) Actually I am trying to do exaclty the same: http://community.dynamics.com/product/crm/crmtechnical/b/sonomapartners/archive/2009/12/27/data-integration-47-migration-using-sql-integration-services-40-ssis-41-2008.aspx Can you tell me more about this mistake?

Try compiling your code in the script component. Seems like there is a compilation error in your script component.http://btsbee.wordpress.com/

Hello, Check out the link below. It may help you. http://stackoverflow.com/questions/2333371/error-in-ssis-script-component

check out if you have defined the variables properly in the script component below (there should not be any duplication of the variable names, or wrong data type etc): Setup Script Component Drag and Drop Script Component to the design pane.Select Transformation and then click OK.Connect the two shapes by dragging the green arrow from Excel Source to Script Component.Double click the script component to open up the Script Transformation Editor.Select the columns that you would like to send to MSCRM from the Input Column window. In this example, I selectedFirst Name, Last Name, Phone and Email Address. Remove Output in the Inputs and Outputs section since we are not going to output anything in this example.Click on the Script tab, click on Edit Script button. The Visual Studio window should open. Please mark the post as answered if it answers your question

using System; using System.Data; using Microsoft.SqlServer.Dts.Pipeline.Wrapper; using Microsoft.SqlServer.Dts.Runtime.Wrapper; using SC_8bcd63e603cd4d3ca95fc2cd201f2c84.csproj.CrmSdk; [Microsoft.SqlServer.Dts.Pipeline.SSISScriptComponentEntryPointAttribute]; public class ScriptMain : UserComponent { private CrmService service = null; public override void PreExecute() { base.PreExecute(); base.PreExecute(); CrmAuthenticationToken token = new CrmAuthenticationToken(); token.AuthenticationType = 0; token.OrganizationName ="-------Test03"; service = new CrmService(); service.Url = "http://--------/mscrmservices/2007/crmservice.asmx"; service.CrmAuthenticationTokenValue = token; service.Credentials = System.Net.CredentialCache.DefaultCredentials; } public override void PostExecute() { base.PostExecute(); } public override void Input0_ProcessInputRow(Input0Buffer Row) { contact con = new contact(); con.firstname = Row.Colonna1; con.lastname = Row.Collonna2 ; con.telephone1 = "234234"; con.emailaddress1 = "fasfsd@dsfasdf.ol"; service.Create(con);

using System; using System.Data; using Microsoft.SqlServer.Dts.Pipeline.Wrapper; using Microsoft.SqlServer.Dts.Runtime.Wrapper; using SC_8bcd63e603cd4d3ca95fc2cd201f2c84.csproj.CrmSdk; [Microsoft.SqlServer.Dts.Pipeline.SSISScriptComponentEntryPointAttribute]; public class ScriptMain : UserComponent { private CrmService service = null; public override void PreExecute() { base.PreExecute(); base.PreExecute(); CrmAuthenticationToken token = new CrmAuthenticationToken(); token.AuthenticationType = 0; token.OrganizationName ="-------Test03"; service = new CrmService(); service.Url = "http://--------/mscrmservices/2007/crmservice.asmx"; service.CrmAuthenticationTokenValue = token; service.Credentials = System.Net.CredentialCache.DefaultCredentials; } public override void PostExecute() { base.PostExecute(); } public override void Input0_ProcessInputRow(Input0Buffer Row) { contact con = new contact(); con.firstname = Row.Colonna1; con.lastname = Row.Collonna2 ; con.telephone1 = "234234"; con.emailaddress1 = "fasfsd@dsfasdf.ol"; service.Create(con); BTW the web references seems to work fine indeed I can see the method and the fields of the CRM. But I cannot get why I have these mistakes ....

have you set the "ReadWriteVariables" or "ReadOnlyVariables" property? to select the variables you are using in the operation? this step is missing from the example. "ReadOnlyVariables": You select the variables that you want to pass to the script component but do not want to update the values. "ReadWriteVariables" You select the variables that you want to pass to the script component and want to update their values from within the script component. this property is on the "Script Component Editor" dialog. Please mark the post as answered if it answers your question

Hi thanks for the help. There were a very very very simple missing thing. SDK library missing. After installing it ... all seems working perfecgly. Thanks for the support. I apologize for the questions but I am a newbie in this world.

Hi thanks for the help. There were a very very very simple missing thing. SDK library missing. After installing it ... all seems working perfecgly. Thanks for the support. I apologize for the questions but I am a newbie in this world. please remember, if you are including the XRM dlls to the ssis packages, then you have to install those dlls to the GAC of server where the packages will run. By d way, you can separate the data import and data processing mechanism separately : ssis to data import to some staging database, and then making a console application using XRM dll(or pure WCF calls) toimport those data into CRM. regards joon

Hi thanks for the help. There were a very very very simple missing thing. SDK library missing. After installing it ... all seems working perfecgly. Thanks for the support. I apologize for the questions but I am a newbie in this world.

Hi thanks for the help. There were a very very very simple missing thing. SDK library missing. After installing it ... all seems working perfecgly. Thanks for the support. I apologize for the questions but I am a newbie in this world. please remember, if you are including the XRM dlls to the ssis packages, then you have to install those dlls to the GAC of server where the packages will run. By d way, you can separate the data import and data processing mechanism separately : ssis to data import to some staging database, and then making a console application using XRM dll(or pure WCF calls) toimport those data into CRM. regards joon