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

ignore Desktop.ini file in DropBox Folder While For each Loop Iteration Expand / Collapse
Author
Message
Posted Thursday, February 14, 2013 4:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, September 16, 2013 11:20 AM
Points: 45, Visits: 139
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
Posted Friday, February 15, 2013 8:51 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 5:14 AM
Points: 119, Visits: 486
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
Posted Friday, February 15, 2013 11:12 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, September 16, 2013 11:20 AM
Points: 45, Visits: 139
thanks . your soln worked, again thanks
Post #1420693
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse