I would need to make a SSIS package which must to watch all the day long if a file come and then save into a variable that path+file.
FileWatcher task do that for me or better totally focusing this requirement in a conventional .NET Script using IO classes and all that sort of stuff?
OK, what about this here: http://www.sqlis.com/default.aspx?23HTH, jens Suessmeyer.
http://www.sqlserver2005.de
|||anyone got any sample on how to use the File Watcher Task component?
I used file system watcher to read excel on my pc it worked fine, but when I tried to read the excel from SharePoint it did't work. The FileWatcher box showing the yellow color for long time that I had to stop the ssis.
So my question what is the cause of this. Do i need to set something or am i missing something? Please help.
Plase
|||What is the path you are using?
I think of sharepoint files as being accessed via http, and of course it will not work for that.
|||Have you try enabaling package logging and letting it run until it finish?
It would be ggod to see what is reported in log execution.
|||They can be referenced by UNC paths (like \\my.server.org\sites\MySite\Shared Documents\myfile.xls) but I believe that only works if you are on the same network as the server - not over the web.|||Thank you everybody. Sorry I used file Watcher Task, as provided on SQLIS.com, in SSIS and used UNC paths and http to connect SharePoint but it did not connect . Am i missing somethig? Since if I used the watcher task to connect to my local computer it worked.|||
AU.T wrote:
Thank you everybody. Sorry I used file Watcher Task, as provided on SQLIS.com, in SSIS and used UNC paths and http to connect SharePoint but it did not connect . Am i missing somethig? Since if I used the watcher task to connect to my local computer it worked.
Try making a connection using Execute Process to do a "net use" first - that will make sure that you can connect and have security permissions. I've also found that when using UNC paths to SharePoint, I usually have to make an initial connection to establish my credentials before I can access it programmatically.
