Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to Check whether the filename is todays file or not(filename like CLM_2014050). Expand / Collapse
Author
Message
Posted Saturday, April 5, 2014 6:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 17, 2014 9:17 PM
Points: 8, Visits: 30
Hi All,

I have file name like this CLM_20140504.I will get file everyday..I just need to check whether file is today's file and then process it.Please let me know how we can do this.

CLM will be common and date should be today's date.tomorrow file name will be CLM_20140604.I need to compare current date with filename date i.e 20140504.







Thanks
Post #1558719
Posted Saturday, April 5, 2014 6:11 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:23 AM
Points: 5,047, Visits: 11,799
naresh0407 (4/5/2014)
Hi All,

I have file name like this CLM_20140504.I will get file everyday..I just need to check whether file is today's file and then process it.Please let me know how we can do this.

CLM will be common and date should be today's date.tomorrow file name will be CLM_20140604.I need to compare current date with filename date i.e 20140504.

Thanks


The standard way of doing this is to archive the file to a different folder after processing it.

So your import (or whatever) just processes what is in the 'infiles' folder, regardless of its name.

One of the problems with your proposed method is what to do if the server is down for a day - you have to mess about forcing yesterday's file to be processed.

Another problem you will get is that the number of files in the folder builds up over time and you'll never be sure that all of them have been processed.



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1558721
Posted Saturday, April 5, 2014 6:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 17, 2014 9:17 PM
Points: 8, Visits: 30
Thanks for the reply..Just need to validate the filename CLM_20140504..Could you please let me know how can we validate.Today date is 20140504 so the CLM_20140504 is valid file.

File name should be with today's date.

If the file name is CLM_20140404 then this is yesterday's file so not valid.So we cannot process yesterday's file today since date in the file 20140404.
Post #1558729
Posted Saturday, April 5, 2014 4:28 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 1:41 PM
Points: 1,773, Visits: 4,641
naresh0407 (4/5/2014)
.Just need to validate the filename CLM_20140504..Could you please let me know how can we validate.Today date is 20140504 so the CLM_20140504 is valid file.


Assuming that you have gotten the file name in a variable, then split it (remove the prefix) in an expression to retain the date part. Use an execute sql task to run this code on the sql server
select convert(varchar(32),getdate(),112)

and compare the two.
Post #1558796
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse