ignore Desktop.ini file in DropBox Folder While For each Loop Iteration

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » ignore Desktop.ini file in DropBox Folder...

ignore Desktop.ini file in DropBox Folder While For each Loop Iteration

Rate Topic

Display Mode

Topic Options

Author

Message

iamsql1

Posted Thursday, February 14, 2013 4:48 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 29, 2013 7:59 AM
Points: 24, Visits: 86

hi,
i am writing ssis package having For Each Loop Container Which iterates through DropBox Folder ..

But when it iterates, it gives error : Desktop.ini File in DropBox is not Recognized.

How do i ignore this .ini file while iterating through Dropbox ?

Post #1419980

Paul Hernández

Posted Friday, February 15, 2013 8:51 AM

Valued Member

Group: General Forum Members
Last Login: Friday, May 17, 2013 7:09 AM
Points: 73, Visits: 253

Hi,

Why is the difference between a regular folder and a dropbox folder?

If there's no difference I think you only need to filter which file extension do you want to read. The problem could be if you want to read all of the extensions except *.ini or this particular .ini file. There´s no a direct way to do it, I mean, with a dropdown list or a checkbox, but you could write an expresion to determine which files you want to process.

Hier is a great example.

Kind Regards.

Paul Hernández
http://hernandezpaul.wordpress.com/
https://twitter.com/paul_eng

Post #1420601

iamsql1

Posted Friday, February 15, 2013 11:12 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 29, 2013 7:59 AM
Points: 24, Visits: 86

thanks . your soln worked, again thanks

Post #1420693

« Prev Topic | Next Topic »

Permissions