Check Files existence in a folder

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Check Files existence in a folder

15 posts, Page 1 of 2

1 2 »»

Check Files existence in a folder

Rate Topic

Display Mode

Topic Options

Author

Message

marees.inspire

Posted Tuesday, November 02, 2010 1:03 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, April 03, 2013 2:44 PM
Points: 60, Visits: 237

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.

Post #1014303

Raunak Jhawar

Posted Tuesday, November 02, 2010 2:51 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 11:25 PM
Points: 946, Visits: 1,739

It depends, largely.

Please google WQL

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum

Post #1014328

Phil Parkin

Posted Tuesday, November 02, 2010 3:05 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 1:17 PM
Points: 4,234, Visits: 9,470

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.

____________________________________________________________________________________________

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

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #1014331

Adiga

Posted Tuesday, November 02, 2010 3:54 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:50 AM
Points: 1,618, Visits: 20,898

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

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

Post #1014344

steveb.

Posted Tuesday, November 02, 2010 4:01 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 7:42 AM
Points: 2,802, Visits: 7,103

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

Post #1014346

Raunak Jhawar

Posted Tuesday, November 02, 2010 4:02 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 11:25 PM
Points: 946, Visits: 1,739

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

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum

Post #1014349

Raunak Jhawar

Posted Tuesday, November 02, 2010 4:06 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 11:25 PM
Points: 946, Visits: 1,739

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.

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum

Post #1014351

Pulivarthi Sasidhar

Posted Tuesday, November 02, 2010 4:30 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 5:30 AM
Points: 870, Visits: 522

Hi,

Use Script Task go to design script
U can write C# or VB Script for the same

Cheers!
Sasidhar Pulivarthi

Post #1014356

Phil Parkin

Posted Tuesday, November 02, 2010 4:32 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 1:17 PM
Points: 4,234, Visits: 9,470

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?

____________________________________________________________________________________________

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

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #1014359

Raunak Jhawar

Posted Tuesday, November 02, 2010 4:38 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 11:25 PM
Points: 946, Visits: 1,739

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 Smile

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum

Post #1014360

« Prev Topic | Next Topic »

15 posts, Page 1 of 2

1 2 »»

Permissions