Data Flow Task Hangs forever

I am new to SSIS, I have developed a simple solution that takes data from a FLAT FILE SOURCE, does some data conversions and Inserts this data into a database table using OLEDB Destination Task. My problem is it works fine on my test database, When I change the database connection, it gets stuck forever in the the Control Flow task and never gets into data flow task(The Data Flow Task continues to remain yellow instead of turning Green).

After around 30 minutes, it goes forward and gives me an error at OLEDB destination block saying "Out Of Memory" as shown below.

[OLE DB Destination [589]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8007000E. An OLE DB record is available. Source: "Microsoft Cursor Engine" Hresult: 0x8007000E Description: "Out of memory.".

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "OLE DB Destination" (589) failed with error code 0xC0202009 while processing input "OLE DB Destination Input" (602). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.

Please Help me with this.