SSIS Data Flow Script Component

• hsoj17

  SSC-Addicted

  Points: 465

  More actions

  December 10, 2009 at 7:02 am

  #218632

  Description pretty much says it all. Here is my situation.

  I've created a very simplistic SSIS package. There is one object variable and one data flow task. Within the data flow task there is a source script component with a column on it going to a record set destination of our variable. Within the script components' script I've added the Microsoft.Web.Services3 and System.Web.Services references. Directly After the CreateNewOutputRows function I've added a new class definition:

  public partial class FinancialResultsWse : Microsoft.Web.Services3.WebServicesClientProtocol

  {

  }

  Running this is the dev studio works just find. Uploading it to the SQL Server and running the package works just fine as well. The problem I'm having is that after adding this to a Job it will fail witht eh following error:

  Executed as user:abc\Administrator. Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:17:34 AM Error: 2009-12-10 08:17:37.55 Code: 0xC0047062 Source: Data Flow Task Script Component [1] Description: 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.CreateUserComponent() End Error Error: 2009-12-10 08:17:37.66 Code: 0xC0047062 Source: Data Flow Task Script Component [1] Description: 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.CreateUserComponent() End Error Error: 2009-12-10 08:17:37.67 Code: 0xC004706B Source: Data Flow Task SSIS.Pipeline Description: "component "Script Component" (1)" failed validation and returned validation status "VS_ISBROKEN". End Error Error: 2009-12-10 08:17:37.67 Code: 0xC004700C Source: Data Flow Task SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2009-12-10 08:17:37.67 Code: 0xC0024107 Source: Data Flow Task Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:17:34 AM Finished: 8:17:37 AM Elapsed: 2.906 seconds. The package execution failed. The step failed.

  I've tried other things such as adding a new class file and putting the class in there, but this comes up with the same error.

  I'm running SQL Server 2008 on Windows Server 2008 via Hyper-V with VS 2008 as the dev environment.

  Can anyone offer their assistance please?

  Thanks,

  Josh