You are saying; you are loading flat file as destination; then you are saying that you are importing data from your flat file to sql server table?

these two are seemingly...

Just to add on what others already said; you have an option to repair the specific page in RESTORE DATABASE COMMAND;

RESTORE DATABASE yourdb PAGE = '1:94299'

FROM DISK = 'C:\yourdb.bak'

WITH NORECOVERY

For...

Dear Ravi,

thanks for sharing info;

I am not that good at Storages.

Anyways, as a quick check, if you have available required space; can you switch the backup of each job...

Please tell us, what is your "ModifiedDate" column; I assume that since you are trying to import from a flat file; it must be a text; now, you have to...

Dear Ravi,

From your post, it is not clear whether these two jobs are running on the same servers or on different servers; secondly; the backup drives used for each server,...

Dear George,

Scripting can be done using either Script Task or ActiveX Script Task;

Script task has the power to write code in VB.NET or C#.NET; so you get more object model...