Is there or does SSIS has a mechanism or a task that allows montoting the
arrival of a file in a directory which wiould be the start point for
launching the package, something like filewatcher in .Net.
Second question, can I architecte a package that monitors modifications in
one or several columns in a table.

Thanks

Hello,

The guys at SQLIS.com have written a file watcher task.

As for monitoring a column change, this is possible using query notifications.
You would have to write an task/custom component that sets up a query notification.
The task will then wait until a notification is recieved.


Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons


Show quoteHide quote

Hi,
From your description, I understand that you had two questions:
1. Could some SSIS task help you monitor the arrival of a file in a
directory?
2. Could a SSIS package monitor table fields changes?
If I have misunderstood, please let me know.

For your first question, you can use WMI Event Watcher Task to monitor if a
new file appears in a specific directory.
The query is like this:
SELECT * FROM __InstanceCreationEvent WITHIN 10
WHERE TargetInstance ISA "CIM_DirectoryContainsFile"
AND TargetInstance.GroupComponent = "Win32_Directory.Name=\"c:\\\\Data\""

For more information, please refer to:
SQL Server 2005 - SQL Server Integration Services - Part 10
http://www.databasejournal.com/features/mssql/article.php/3552621


For your second question, I am afraid that you may need to consider to use
Query Notification whereas it has many restrictions.  Please refer to:
Creating a Query for Notification
http://msdn2.microsoft.com/en-US/library/ms181122.aspx

Hope this helps. Please feel free to let me know if you have any other
questions or concerns.

Charles Wang
Microsoft Online Community Support

======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

Hi,
I would like to check with you to see if you need further assistance on
this issue. We appreciate your posting back at your convenience.

Thanks for using Microsoft Online Managed Newsgroup. If you have any other
questions or concerns, please feel free to let us know.

Sincerely yours,
Charles Wang
Microsoft Online Community Support

Thanksforyour responses, I downloaded thecomponent and will give it a go as
well as the notificcation stuff this week. I wil let you know
Thanks again for the info

Show quoteHide quote

Thanks for your updating and response.

We look forward to your response. If you have any other questions or
concerns, please feel free to let us know.

Have a great day!

Charles Wang
Microsoft Online Community Support

======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

Hi,
How is this issue going? Please feel free to let us know if it persists.

Look forward to your response and have a good day!

Sincerely yours,
Charles Wang
Microsoft Online Community Support

======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

Little Lock Symbols
lost sa password due to loss of employee
GoDaddy SQL Web Admin -- Importing CSV file
detached database disappears?
Scripting db creation