Run SSIS Package error in SQL Agent

I run my SSIS package in SSDT and Success, but when I run the package using SQL Agent and get error.

The error message is below

copy_r_bp:Error: System.Data.Odbc.OdbcException (0x80131937): ERROR [HY001] Out of memory while reading tuples.
   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
   at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.PreExecute()
   at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper)

Can you help me ? Or is there any solution to set schedule to execute the package ?

Thanks

The error is straight-forward and tells you the exact problem: you are using up all the memory. Solution: instead of a large read, divide your read to smaller partitions and read everything using a cycle.