Programmatically generating SSIS packages for transferring data with 1 dataflow: 1 OleDbSource -> 1 Balanced Data Distributor -> multiple outputs to OleDbDestinations with same configuration (destination table, rows per batch and other settings) crashes randomly, regardless of number of packages and number of outputs.It crashes after successfully creating few packages with described package structure. No exception is caught with try/catch. Application crashes even while debugging within Visual Studio - VS does not even catch exception. At the moment of crash, message box is displayed: vshost-clr2.exe has stopped working with details:Problem signature: Problem Event Name: APPCRASH Application Name: ConsoleApplication1.vshost.exe Application Version: 10.0.30319.1 Application Timestamp: 4ba2084b Fault Module Name: StackHash_7736 Fault Module Version: 6.0.6001.18538 Fault Module Timestamp: 4cb73957 Exception Code: c0000374 Exception Offset: 00000000000a7857 OS Version: 6.0.6001.2.1.0.272.7 Locale ID: 1033 Additional Information 1: 7736 Additional Information 2: db51d7aa2a2cceb6f6facb10f783553e Additional Information 3: b29f Additional Information 4: f747c08658e6d0cc26be4ac3422a2323I found no workaround for this problem. None of following was of any use: generating packages using SQL Server dlls directly or using EzPackage; starting new thread for each package; starting new process (.EXE) for each package; creating new ApplicationDomain for each package; changing number of BDD outputs and OleDbDestinations.Crash occurs on line of code that connects BDD output and OleDbDestination.Since it crashes randomly, I made no conclusions regarding data types or such.I've found articles on the Internet suggesting to turn Data Executino Prevention off for my application but Windows tells me that I can't turn DEP off for this application.Just edited this connect item, here is additional info:-in x64 and Any CPU configurations of application that creates packages, it crashes after generating two or three pacakge-in x86 configuration of application that creates packages, it creates much more packages than in x64, and randomly throws AccessViolationException caught by VS:StackTrace: at Microsoft.SqlServer.Dts.Runtime.Executables.Add(String moniker) at Microsoft.SqlServer.SSIS.EzAPI.EzExecutable.CreateExecutable() at Microsoft.SqlServer.SSIS.EzAPI.EzExecutable..ctor(EzContainer parent) at Microsoft.SqlServer.SSIS.EzAPI.EzDataFlow..ctor(EzContainer parent) at Microsoft.SqlServer.SSIS.EzAPI.EzSrcDF`1..ctor(EzContainer parent) at Microsoft.SqlServer.SSIS.EzAPI.EzSrcConnDF`2..ctor(EzContainer parent) at Microsoft.SqlServer.SSIS.EzAPI.EzTransformDF`3..ctor(EzContainer parent) at Microsoft.SqlServer.SSIS.EzAPI.EzTransDestDF`4..ctor(EzContainer parent) at Microsoft.SqlServer.SSIS.EzAPI.EzTransDestConnDF`5..ctor(EzContainer parent) at ConsoleApplication1.STGPackage..ctor(String srcSrv, String srcDb, String tblNm, String dstSrv, String dstDb) in c:\app\STGPackage.cs:line 18 at ConsoleApplication1.Program.GenPkg(String table) in c:\app\Program.cs:line 287 at ConsoleApplication1.Program.GeneratePackages(String[] args) in c:\app\Program.cs:line 263 at ConsoleApplication1.Program.Main(String[] args) in c:\app\Program.cs:line 124 at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args) at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args) at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly() at System.Threading.ThreadHelper.ThreadStart_Context(Object state) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart()
Product Language
Version
Category
Operating System
Operating System Language
Steps to Reproduce
Actual Results
Expected Results
Platform
Virtualization
Please wait...