Check Files existence in a folder

Question

Post reply

Check Files existence in a folder

marees.inspire

Ten Centuries

Points: 1324
More actions
November 2, 2010 at 1:03 am

#149176

Hi All,
how to implement the below req in SSIS:
how to find out whether any file is present in the specified folder.
Note: we dont know about the file name. Just we need to check whether any files present or not.
Thanks in Advance.

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 1

Raunak Jhawar

SSCoach

Points: 15701

November 2, 2010 at 2:51 am

#1245233

It depends, largely.

Please google WQL

Raunak J

Phil Parkin SSC Guru Points: 246960 More actions · Answer 2

Depends on what you will do next.

You might just be able to use a Foreach loop and put your 'file(s) found' processing inside it.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Adiga One Orange Chip Points: 27284 More actions · Answer 3

You may find xp_fileexists extended stored procedure useful. More information on this XP here

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

steveb. SSC-Forever Points: 46733 More actions · Answer 4

as another suggestion; the way we do it is to use a script task with the File.Exists Method

http://msdn.microsoft.com/en-us/library/system.io.file.exists.aspx

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 5

Adiga (11/2/2010)
You may find xp_fileexists extended stored procedure useful. More information on this XP here

The OP says, file name not known

Raunak J

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 6

One of the suitable approach would be to watch the said directory using a FileSystemWatcher and fire appropriate events as associated. This seems doable as the system does not deems necessary for a filename to be known.

Raunak J

Pulivarthi Sasidhar SSCertifiable Points: 6706 More actions · Answer 7

Hi,

Use Script Task go to design script

U can write C# or VB Script for the same

Cheers!

Sasidhar Pulivarthi

Phil Parkin SSC Guru Points: 246960 More actions · Answer 8

Pulivarthi Sasidhar (11/2/2010)
Hi,
Use Script Task go to design script
U can write C# or VB Script for the same
Cheers!
Sasidhar Pulivarthi

What does this give the OP that Steveb's post did not?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 9

Phil Parkin (11/2/2010)
Pulivarthi Sasidhar (11/2/2010)
Hi,
Use Script Task go to design script
U can write C# or VB Script for the same
Cheers!
Sasidhar Pulivarthi
What does this give the OP that Steveb's post did not?

In any case, File.Exists() cannot be used :-):-):-)

Raunak J

Phil Parkin SSC Guru Points: 246960 More actions · Answer 10

True 🙂

Directory.GetFiles will probably do the job.

But so will a FEL, without the need for any code.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 11

Think Big...Think Windows Service that will poll a directory implementing Windows Management Instrumentation Events..lol...

Yes Phil FEL can be used but the ST has to invlove a suitable code for threading to minimize the resource usage for all the time as long as file is not found...So a better approach should be a WQL/FileSystemWatcher as it will keep the package in dormant state as long as file is not found at the designated root folder.;-)

Raunak J

Phil Parkin SSC Guru Points: 246960 More actions · Answer 12

You are using a lot of guesswork here.

A quote from the original post:

how to find out whether any file is present in the specified folder.
Note: we dont know about the file name. Just we need to check whether any files present or not.

..and that's it.

You have somehow extrapolated an extravagant requirement from this. Maybe the check needs to be done only once a day/week/month - who knows?

I suspect you have the geek-defect gene installed 🙂

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 13

Phil Parkin (11/2/2010)
You are using a lot of guesswork here.

Somehow, I don't think so. 🙂

Raunak J

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 14

Raunak Jhawar (11/2/2010)
Think Big...Think Windows Service that will poll a directory implementing Windows Management Instrumentation Events..lol...
Yes Phil FEL can be used but the ST has to invlove a suitable code for threading to minimize the resource usage for all the time as long as file is not found...So a better approach should be a WQL/FileSystemWatcher as it will keep the package in dormant state as long as file is not found at the designated root folder.;-)

A VB task could very quick get a count of the files in a directory.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]