Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

In my application I have a process which picks the scanned
files (tif format) from a shared location and it links to
application and shown on it.The actuall issue is that my
process picks the file before it is completly written or
scanned which results in displaying few parts of the image
or incomplete image.I need to check if the file is not
completly scanned or written then do not link it to
application.Please help if any body tell me that how can i
check that file is in written phase or locked through
DTS.thanking you in advance

Question Posted / zeeshan


In my application I have a process which picks the scanned files (tif format) from a shared locati..

Answer / Avanish Kumar Pandey

To prevent your process from picking incomplete TIFF files, you can implement the following approach:
1. Use File System Watcher or a similar technology to monitor changes in the shared location for new files and wait until the file's last write time remains unchanged for a certain period (e.g., 5 minutes) before picking it up.
2. You can check if the TIFF file is locked by scanner software using APIs provided by your application or by using the `File.Exists` method in C# to ensure the file is not being accessed by another process.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Explain transaction server explicit transaction?

1 Answers  

What is faster join or union?

1 Answers  

What is primary key and example?

1 Answers  

How many instances per computer are there in sql server 2000?

1 Answers  

What is trigger ?

7 Answers   Cap Gemini, SQL,

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1 Answers   IBM,

Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

3 Answers   Accenture,

Is it possible in sql table to have more than one foreign key?

1 Answers  

What is indexing?

0 Answers   AOL,

Is it safe to delete log files?

1 Answers  

What is serializable?

1 Answers  

WHAT OPERATOR PERFORMS PATTERN MATCHING?

2 Answers   CarrizalSoft Technologies, CTS,

For more SQL Server Interview Questions Click Here
Categories