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

SSIS Script task with C# Help Expand / Collapse
Author
Message
Posted Tuesday, October 29, 2013 8:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 29, 2014 11:20 AM
Points: 9, Visits: 30
Hi Fellow,

I have SSIS Package which does ETL process. I have For each loop container in that container I have a Script task which check if file exits in the folder. if yes then run data flow now I want to add one new functionality which check if file open while archiving. it will catch that file and throw a log in ssis

Thanks
Post #1509385
Posted Wednesday, November 6, 2013 11:54 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, December 15, 2014 3:09 AM
Points: 1,046, Visits: 1,846
Ravikptel (10/29/2013)

which check if file open while archiving. it will catch that file and throw a log in ssis


Can you re-phrase this text. What is it that you want to achieve?


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 #1512099
Posted Thursday, November 7, 2013 8:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 29, 2014 11:20 AM
Points: 9, Visits: 30
Hi ,

if I want to see(check) file is open while archiving from the folder. if that file is open then it will log in to log table . I need that code which catch open file.

Thank you
Post #1512294
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse