I face a problem running a SSIS 2012 package with a custom control through the SQL Server Agent. It comes up with a lineage id problem. See error from SQL Agent History... Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 1:13:00 PM Error: 2013-02-05 13:13:27.27 Code: 0xC0047062 Source: QCR TableDifference [380] Description: System.ArgumentException: Value does not fall within the expected range. at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSBufferManager100.FindColumnByLineageID(Int32 hBufferType, Int32 nLineageID) at SqlBi.SSIS.Components.TableDifference.OutputInformation..ctor(TableDifference container, OutputType type, OutputFlow output) at SqlBi.SSIS.Components.TableDifference.PreExecute() at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper) End Error Error: 2013-02-05 13:13:27.27 Code: 0xC004701A Source: QCR SSIS.Pipeline Description: TableDifference failed the pre-execute phase and returned error code 0x80070057. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 1:13:00 PM Finished: 1:13:29 PM Elapsed: 28.72 seconds. The package execution failed. The step failed. I don't receive this error when I run the package in Visual Studio, so I am not sure what I am doing wrong. Does anyone have any ideas? Thanks, Steve

Hi QCCAT, A SQL Server Agent job step may fail to start a package even though the package runs successfully in SQL Server Data Tools (SSDT) and from the command line. There are some common reasons for this issue and several recommended solutions. For more information, see the following resources. 1. Microsoft Knowledge Base article, An SSIS package does not run when you call the SSIS package from a SQL Server Agent job step 2. Video, Troubleshooting: Package Execution Using SQL Server Agent (SQL Server Video), in the MSDN Library. For more details about it, please refer to: http://msdn.microsoft.com/en-us/library/ms141701.aspx#trouble Thanks, Eileen If you have any feedback on our support, please click here Eileen Zhao TechNet Community Support