locked
SQL 2012 RC0: HResult 0x80070057 error with custom task when using MainPipeClass RRS feed

  • Question

  • Hi,

    We have a C# windows service that creates SSIS packages with custom tasks on the fly to extract and load data. We have migrated our entire SQL code base to 2012 RC0 using SQL Server Data Tools. Now we are facing this issue for specific types of packages using the MainPipeClass when they execute:

    Error

    occured while extracting source data: System.ApplicationException: Failed to extract the source.[Cannot create a task from XML for task "", type ", {E3CFBEA8-1F48-40D8-91E1-2DEDC1EDDD56}" due to error 0x80070057 "The parameter is incorrect.".

    This GUID is not from our code and seems to be an inherent attribute with the Microsoft.SqlServer.Dts.Pipeline.Wrapper.MainPipeClass per: http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.pipeline.wrapper.mainpipeclass(v=sql.110).aspx

    We have also made the syntax changes for SQL 2012 as per the above article. But still this error persists. 
    Has anyone faced this issue? Are we missing some DTS related component on the server where the SSIS package executes? Kindly help.

    Thanks,
    Shriram

    Tuesday, February 28, 2012 3:18 AM

All replies