Home Forums Data Warehousing Integration Services SSIS Fails with buffer errors when run from a Job - SQL 2008 R2 RE: SSIS Fails with buffer errors when run from a Job - SQL 2008 R2

  • May 5, 2015 at 9:39 pm

    #1795815

    dmayley (5/4/2015)

    Eirikur Eiriksson (5/3/2015)

    Quick questions, is the server running SQL Server? Is AWE enabled on the server? What are the memory (min/max) config of the SQL Server? What is the output of SELECT @@VERRSION?

    😎

    The error message states that it is failing on allocating 5Mb of memory when 6577 Mb are free!

    Eirikur,

    AWE is enabled. Memory Min. 2048, Max. 10,000.

    Select @@version = "Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (Intel X86)

    Jun 17 2011 00:57:23

    Copyright (c) Microsoft Corporation

    Enterprise Edition on Windows NT 6.0 <X86> (Build 6001: Service Pack 1)"

    HTH

    Thanks

    You should press for an update to SP3, many issues both security and functional have been fixed since your sql server's build.

    😎

    Suggest you use PerfMon to check if the OS and the SSIS are pressurized during the package runs, you might want to adjust the MaxMem as Martin suggested.