InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 17:25:41 GMT20http://www.sqlservercentral.com/Forums/Topic1288568-2824-1.aspxCorrections don't take effect until approved.All setWed, 27 Jun 2012 13:23:56 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1288568-2824-1.aspxBig brother must have been watching over me. All is well now :-)Tue, 26 Jun 2012 20:53:05 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1288568-2824-1.aspxIt did not work out the way I had hoped:[img]http://www.sqlservercentral.com/Forums/Attachment11829.aspx[/img]Tue, 26 Jun 2012 07:14:32 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1288568-2824-1.aspxYes you can.Mon, 25 Jun 2012 21:28:01 GMTRaunak Jhawarhttp://www.sqlservercentral.com/Forums/Topic1288568-2824-1.aspxHi Steve,I would like to correct a few minor typos in the article before it is published. Given that it has been scheduled for publication can I modify the article and press "Save & Submit" without affecting its status?Thanks,OrlandoMon, 25 Jun 2012 09:35:26 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1288568-2824-1.aspxJeff, your comments helped settle me down. It's nice to have a timeline now on when I might see the article accepted and potentially published. Thanks as always for all the encouragement and tips along the way.Steve, thanks for your comments. I made the edits you recommended and can definitely appreciate all of a sudden being swamped when someone goes on holiday. It's suspicious how that happens. I appreciate you having a look at the article this morning.Fri, 18 May 2012 12:11:17 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1288568-2824-1.aspxI see the WMI query article and I'll get to it. Right now I have 16 in queue, up from 8 on Monday, and I went through 4 this week. My other editor is on holiday this week and the third is a bit busy.I'll give it a quick glance. If it looks OK, I can do a quick edit. If I see issues, I'll leave it and come back.We are scheduled through next week, but I have 13 articles to schedule today, so likely we are talking mid-late June for the next batch of 5-10 articles I get done. Fri, 18 May 2012 10:11:37 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1288568-2824-1.aspxIt depends on what the backlog for Steve is. Typically, it's been taking 3-4 weeks to be accepted, betwee, 4 and 6 weeks to be scheduled, and between 4 and 8 weeks to be published. Usually about 6 weeks to publish from the day of submittal. Earlier if the topic is particularly hot or Steve had a cancellation.Fri, 18 May 2012 09:40:03 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1288568-2824-1.aspx[quote][b]Jeff Moden (5/18/2012)[/b][hr]Any idea when the first one is coming out, Orlando?[/quote]I do not. I have not received any feedback since submitting the article earlier this week. This being my first article submission I am on pins and needles with anticipation. What has been your experience in terms of how long it may take before the articles are reviewed and you find out if they will be published?Fri, 18 May 2012 08:53:21 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1288568-2824-1.aspxAny idea when the first one is coming out, Orlando?Fri, 18 May 2012 07:38:24 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1288568-2824-1.aspx[quote][b]Raunak Jhawar (5/18/2012)[/b][hr]I want to do one. One fo you and one for me :-P[/quote]Well, I was going to do three that build on one another so it would be my wish to do all three in this area. I already submitted the WMI Event Watcher article requested here and am outlining the second using a third party [u][url=http://www.sqlis.com/post/File-Watcher-Task.aspx]FileWatcherTask[/url][/u] as alluded to above. The third will be how to implement the FileWatcherTask functionality manually in a Script Task. The reason for the third one is that some corporate environments do not make it easy to bring in third-party tools but in general a solution using the .net watcher class will be cleaner than the solution using WMI.Fri, 18 May 2012 06:55:06 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1288568-2824-1.aspxI want to do one. One fo you and one for me :-PFri, 18 May 2012 06:40:35 GMTRaunak Jhawarhttp://www.sqlservercentral.com/Forums/Topic1288568-2824-1.aspx[quote][b]Raunak Jhawar (5/18/2012)[/b][hr]I can take one on 'File Watcher Task", but will this article describe more about .NET classe "FileSystemWatcher" or any other task or .NET class in particular?[/quote]I got it Raunak. I will be doing them as a series.Fri, 18 May 2012 06:38:55 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1288568-2824-1.aspxI can take one on 'File Watcher Task", but will this article describe more about .NET classe "FileSystemWatcher" or any other task or .NET class in particular?Fri, 18 May 2012 03:51:17 GMTRaunak Jhawarhttp://www.sqlservercentral.com/Forums/Topic1288568-2824-1.aspxI was thinking the built in WMI one. The File Watcher would be a separate article (also would be good). One could build on the other.Tue, 24 Apr 2012 09:36:18 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1288568-2824-1.aspxGreat, that sounds like what I was thinking...something simple to get someone started on the technique with screenshots of the SSIS design environment and steps to achieve.Just to clarify because the wording opinted me away from the built-in SSIS tasks, were you looking for something using the WMI Event Watcher in SSIS setup to watch for files, or something built using the third party [u][url=http://ssisfilewatcher.codeplex.com/]File Watcher Task[/url][/u]?Tue, 24 Apr 2012 09:14:29 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1288568-2824-1.aspxPlease do. Keep it simple, take a quick scenario, show some images of how they configure things, how the task flows the data in. Assume a simple Excel -> table with the same schema every time.Mon, 23 Apr 2012 17:26:09 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1288568-2824-1.aspx[quote][b]Steve Jones - SSC Editor (4/23/2012)[/b][hr]Looking for an article on how to import a file automatically into a database using SSIS and the File Watcher Task. Assume some business person drops an Excel file in a folder and then SSIS handles the import.[/quote]Hi Steve, I would be happy to write an article that describes how to do that.Mon, 23 Apr 2012 17:09:14 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1288568-2824-1.aspxLooking for an article on how to import a file automatically into a database using SSIS and the File Watcher Task. Assume some business person drops an Excel file in a folder and then SSIS handles the import.Mon, 23 Apr 2012 16:51:27 GMTSteve Jones - SSC Editor