SSIS OLEDB task was successful but the records were not inserted into the table

0

Hi,

Can anyone explain why SSIS package executes for such a long time and fails with Login time out expired error ? When I try to load the same through BIDS, it executes fine but the OLEDB doesn't insert any records in any of the tables.