September 21, 2011 at 3:31 am
hi,
How to find the file name in the folder if it exists or not.Daily text file is coming in the format ex:21-09-2011 i need to find whether the file exists or not for todays date.
September 21, 2011 at 3:35 am
If you're doing this in T-SQL, you can use xp_cmdshell (if it's enabled) to run a DOS or PowerShell script. However, this is the kind of thing SSIS is designed for, so I would recommend that you use that.
John
September 21, 2011 at 3:38 am
can u tell hw to do in ssis
September 21, 2011 at 3:41 am
Not really. SSIS is a big subject. There are tutorials for getting yourself started in writing SSIS on the Microsoft website - I recommend you take a couple of those, then start writing a simple package. Of course, if you come across any particular issue while you're doing that, then please post back, and somebody will be delighted to help. Sorry I can't be more helpful than that.
John
September 21, 2011 at 4:16 am
nhimabindhu (9/21/2011)
hi,How to find the file name in the folder if it exists or not.Daily text file is coming in the format ex:21-09-2011 i need to find whether the file exists or not for todays date.
Hi,
Are you storing file name in DB??
Shatrughna
September 21, 2011 at 4:20 am
no it is has to read from folder from system
September 21, 2011 at 4:41 am
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply