WMI and moving files

Question

WMI and moving files

Viewing 6 posts - 1 through 7 (of 7 total)

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

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 1

You could setup a script to watch the file for a period of time and see of the file size changes over that time, if it doesn't it could be considered complete if it does then start the wait again..

I've never been particularly a fan of moving files around..

CEWII

Phil Parkin SSC Guru Points: 247183 More actions · Answer 2

You could maybe try the File Watcher task as an alternative and see whether that works better for you.

Rayven SSCarpal Tunnel Points: 4337 More actions · Answer 3

Thanks Phil, the component does exactly what I need and has solved the issue admirably.

---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion.

Phil Parkin SSC Guru Points: 247183 More actions · Answer 4

Phil Parkin

SSC Guru

Points: 247183

April 12, 2013 at 3:39 am

#1605890

Splendid - thanks for posting back.

Phil

Orlando Colamatteo SSC Guru Points: 182293 More actions · Answer 5

Sounds like you are OK with the File Watcher Task, it's a good tool, but I figured I would throw in another option that will help accomplish the same but will not require the installation of a third party component. This one is based on the SSIS Script Task so you can modify the .NET source code in case you need additional functionality down the line:

Using the Script Task in SSIS to Process Data Files When They Arrive[/url]

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

aaron.reese SSChampion Points: 13498 More actions · Answer 6

+1 for the File Wather on SQLIS. We use it all over the place. The 2005 version does not have a pretty config interface but still gets the job done. It needs installing on all dev machines and servers where it may be used.