SSIS - File Watcher Task

Question

SSIS - File Watcher Task

Steve Jones - SSC Editor

SSC Guru

Points: 734434
More actions
April 23, 2012 at 4:51 pm

#273095

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.

Viewing 15 posts - 1 through 15 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Orlando Colamatteo SSC Guru Points: 182276 More actions · Answer 1

Steve Jones - SSC Editor (4/23/2012)
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.

Hi Steve, I would be happy to write an article that describes how to do that.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Steve Jones - SSC Editor SSC Guru Points: 734434 More actions · Answer 2

Please 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.

Orlando Colamatteo SSC Guru Points: 182276 More actions · Answer 3

Great, 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 File Watcher Task[/url]?

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Steve Jones - SSC Editor SSC Guru Points: 734434 More actions · Answer 4

I 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.

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 5

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?

Raunak J

Orlando Colamatteo SSC Guru Points: 182276 More actions · Answer 6

Raunak Jhawar (5/18/2012)
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?

I got it Raunak. I will be doing them as a series.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 7

I want to do one. One fo you and one for me 😛

Raunak J

Orlando Colamatteo SSC Guru Points: 182276 More actions · Answer 8

Raunak Jhawar (5/18/2012)
I want to do one. One fo you and one for me 😛

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 FileWatcherTask 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.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Jeff Moden SSC Guru Points: 1003861 More actions · Answer 9

Any idea when the first one is coming out, Orlando?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Orlando Colamatteo SSC Guru Points: 182276 More actions · Answer 10

Jeff Moden (5/18/2012)
Any idea when the first one is coming out, Orlando?

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?

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Jeff Moden SSC Guru Points: 1003861 More actions · Answer 11

It 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.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Steve Jones - SSC Editor SSC Guru Points: 734434 More actions · Answer 12

I 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.

Orlando Colamatteo SSC Guru Points: 182276 More actions · Answer 13

Jeff, 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.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Orlando Colamatteo SSC Guru Points: 182276 More actions · Answer 14

Hi 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,

Orlando

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato