Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 File Watching

Author  Topic 

rcr69er
Constraint Violating Yak Guru

327 Posts

Posted - 2008-06-29 : 18:12:27
Hi

Does anyone know where I can find a way of producing a SSIS package to check if a certain file has been placed in a folder?

Thanks

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-29 : 21:33:39
quote:
Originally posted by rcr69er

Hi

Does anyone know where I can find a way of producing a SSIS package to check if a certain file has been placed in a folder?

Thanks



There is a File Watcher task in SSIS.

Check this out:http://www.sqlis.com/23.aspx
Go to Top of Page

igorblackbelt
Constraint Violating Yak Guru

407 Posts

Posted - 2008-07-08 : 11:51:09
Or if you know .net you can write your own component.

http://msdn.microsoft.com/en-us/library/system.io.filesystemwatcher.aspx


---
http://www.ssisdude.blogspot.com/
Go to Top of Page
   

- Advertisement -