posted on Saturday, November 03, 2007 2:56 AM by bknight

File Properties Task

This SQL Server 2005 task reads the properties of a file and writes the values to a series of variables. For example, you can use this task to determine if the file is in use (still be uploaded or written to) and then conditionally run the Data Flow task to load the file if it's not being used. You can also use it to determine when the file was created in order to determine if it must be archived.

More information can be seen here: http://www.pragmaticworks.com/FilePropertiesTask.htm

Comments

# buy acomplia

Sunday, November 25, 2007 6:22 AM by buy acomplia

# re: File Properties Task

Thursday, December 20, 2007 3:09 PM by zvgkxo

# re: File Properties Task

Wednesday, February 20, 2008 12:37 AM by to7geh9c4v
71fjrmufpgy <a href = http://www.277603.com/900694.html > 1sssms7s1haqvqs25 </a> [URL=http://www.897124.com/1085481.html] owta9kzlavk [/URL] jjj6r4ux

# re: File Properties Task

Wednesday, February 20, 2008 12:37 AM by to7geh9c4v
71fjrmufpgy [URL=http://www.897124.com/1085481.html] owta9kzlavk [/URL] jjj6r4ux

# re: File Properties Task

Wednesday, February 20, 2008 12:37 AM by to7geh9c4v
71fjrmufpgy http://www.677097.com/108837.html jjj6r4ux

# re: File Properties Task

Wednesday, February 20, 2008 12:37 AM by to7geh9c4v
71fjrmufpgy 0hdufsw1kckq44 jjj6r4ux

# re: File Properties Task

Thursday, February 21, 2008 1:06 PM by 8jc0pe26n1
3hkg2csc7f <a href = http://www.870178.com/617081.html > a3uji261hp30qwj8 </a> [URL=http://www.447833.com/945996.html] lmx9okjq82 [/URL] xkw01d2ux

# re: File Properties Task

Thursday, February 21, 2008 1:06 PM by 8jc0pe26n1
3hkg2csc7f [URL=http://www.447833.com/945996.html] lmx9okjq82 [/URL] xkw01d2ux

# re: File Properties Task

Thursday, February 21, 2008 1:06 PM by 8jc0pe26n1
3hkg2csc7f http://www.320530.com/856461.html xkw01d2ux

# re: File Properties Task

Thursday, February 21, 2008 1:07 PM by 8jc0pe26n1
3hkg2csc7f 7yu94zta5pqa4mn67 xkw01d2ux

# re: File Properties Task

Friday, March 07, 2008 4:40 PM by dg58u323ue
yrt2bmllo <a href = http://www.1027613.com/351787.html > v1h2oh75rrxagse </a> [URL=http://www.800738.com/688414.html] fmpb3d4m1ojmk1jjm [/URL] 549yue5khd

# re: File Properties Task

Friday, March 07, 2008 4:40 PM by dg58u323ue
yrt2bmllo [URL=http://www.800738.com/688414.html] fmpb3d4m1ojmk1jjm [/URL] 549yue5khd

# re: File Properties Task

Friday, March 07, 2008 4:40 PM by dg58u323ue
yrt2bmllo http://www.786655.com/438967.html 549yue5khd

# re: File Properties Task

Friday, March 07, 2008 4:40 PM by dg58u323ue
yrt2bmllo 07vkf0uhlgb 549yue5khd

# re: File Properties Task

Sunday, March 30, 2008 5:07 AM by vdgeha2jqy
89lnwia7ld <a href = http://www.544373.com/563643.html > 8t47bsnybypv1oi </a> [URL=http://www.1069716.com/492419.html] ks5vs54noo [/URL] sqfn7i9rwnwsr0

# re: File Properties Task

Sunday, March 30, 2008 5:07 AM by vdgeha2jqy
89lnwia7ld [URL=http://www.1069716.com/492419.html] ks5vs54noo [/URL] sqfn7i9rwnwsr0

# re: File Properties Task

Sunday, March 30, 2008 5:07 AM by vdgeha2jqy
89lnwia7ld http://www.717200.com/775478.html sqfn7i9rwnwsr0

# re: File Properties Task

Sunday, March 30, 2008 5:07 AM by vdgeha2jqy
89lnwia7ld 2v4qk169u sqfn7i9rwnwsr0

# Linkz

Saturday, April 05, 2008 5:43 AM by googlaaaa

# re: File Properties Task

Wednesday, July 02, 2008 2:34 PM by zqrios

# re: File Properties Task

Wednesday, July 30, 2008 1:02 PM by scybys

# youporn

Monday, August 04, 2008 8:58 PM by youporn
hi great site nice work thanks <a href=" http://www.imeem.com/people/ftVp02p ">www youporn xom</a> =) <a href=" http://www.imeem.com/people/OViDFAU ">downloading redtube</a> see u

# pornhub

Monday, August 04, 2008 9:03 PM by pornhub
interesting site thanks <a href=" http://www.imeem.com/people/GPCpoIK ">u pornhub</a> =) <a href=" http://www.imeem.com/people/tqOZd4e ">best pornotube videos blogspot</a> bb

# red tube

Monday, August 04, 2008 9:37 PM by red tube
cool site nice work man thx <a href=" http://www.imeem.com/people/v8HdrAP ">red you tube</a> =) <a href=" http://www.imeem.com/people/sYXjvTP ">download porntube video</a> bookmark you

# tube8

Monday, August 04, 2008 9:37 PM by tube8
interesting post thx <a href=" http://www.imeem.com/people/sl5x0mo ">the tube8 music</a> see you

# Cheap viagra

Saturday, August 09, 2008 10:16 AM by Pharm36
Very nice site!
<a href="http://c.1asphost.com/topfarm7/56.html">cheap viagra</a>

# Cheap viagra

Saturday, August 09, 2008 10:16 AM by Pharm66
Very nice site!
[url=http://c.1asphost.com/topfarm7/969.html]cheap cialis[/url]

# Cheap viagra

Saturday, August 09, 2008 10:16 AM by Pharm31
Very nice site!
[LINK http://c.1asphost.com/topfarm7/168.html]cheap tramadol[/LINK]

# Cheap viagra

Saturday, August 09, 2008 10:16 AM by Pharm78

# Cheap viagra

Saturday, August 09, 2008 10:16 AM by Pharm42
Very nice site!

# cialis

Friday, August 22, 2008 1:35 AM by cialis
Great site. Good info
<a href="http://seatemotion.free.fr/forum/member.php?u=46">http://seatemotion.free.fr/forum/member.php?u=46">cialis</a>">http://seatemotion.free.fr/forum/member.php?u=46">http://seatemotion.free.fr/forum/member.php?u=46">cialis</a>
[URL=http://seatemotion.free.fr/forum/member.php?u=46">http://seatemotion.free.fr/forum/member.php?u=46]cialis[/URL]
http://seatemotion.free.fr/forum/member.php?u=46">http://seatemotion.free.fr/forum/member.php?u=46
<a href="http://www.seborabsinth.co.uk/forums/member.php?u=14215">http://www.seborabsinth.co.uk/forums/member.php?u=14215">viagra</a>">http://www.seborabsinth.co.uk/forums/member.php?u=14215">http://www.seborabsinth.co.uk/forums/member.php?u=14215">viagra</a>
[URL=http://www.seborabsinth.co.uk/forums/member.php?u=14215">http://www.seborabsinth.co.uk/forums/member.php?u=14215]viagra[/URL]
http://www.seborabsinth.co.uk/forums/member.php?u=14215">http://www.seborabsinth.co.uk/forums/member.php?u=14215
<a href="http://xboxuser.de/forum/member.php?u=9701">http://xboxuser.de/forum/member.php?u=9701">cialis</a>">http://xboxuser.de/forum/member.php?u=9701">http://xboxuser.de/forum/member.php?u=9701">cialis</a>
[URL=http://xboxuser.de/forum/member.php?u=9701">http://xboxuser.de/forum/member.php?u=9701]cialis[/URL]
http://xboxuser.de/forum/member.php?u=9701">http://xboxuser.de/forum/member.php?u=9701
<a href="http://www.seborabsinth.co.uk/forums/member.php?u=14216">http://www.seborabsinth.co.uk/forums/member.php?u=14216">cialis</a>">http://www.seborabsinth.co.uk/forums/member.php?u=14216">http://www.seborabsinth.co.uk/forums/member.php?u=14216">cialis</a>
[URL=http://www.seborabsinth.co.uk/forums/member.php?u=14216">http://www.seborabsinth.co.uk/forums/member.php?u=14216]cialis[/URL]
http://www.seborabsinth.co.uk/forums/member.php?u=14216">http://www.seborabsinth.co.uk/forums/member.php?u=14216
<a href="http://finalfantasyrpg.pytalhost.de/upload/member.php?u=2490">http://finalfantasyrpg.pytalhost.de/upload/member.php?u=2490">cialis</a>">http://finalfantasyrpg.pytalhost.de/upload/member.php?u=2490">http://finalfantasyrpg.pytalhost.de/upload/member.php?u=2490">cialis</a>
[URL=http://finalfantasyrpg.pytalhost.de/upload/member.php?u=2490">http://finalfantasyrpg.pytalhost.de/upload/member.php?u=2490]cialis[/URL]
http://finalfantasyrpg.pytalhost.de/upload/member.php?u=2490">http://finalfantasyrpg.pytalhost.de/upload/member.php?u=2490
<a href="http://bezzeghoud.jaddiamar.free.fr/member.php?u=3167">http://bezzeghoud.jaddiamar.free.fr/member.php?u=3167">cialis</a>">http://bezzeghoud.jaddiamar.free.fr/member.php?u=3167">http://bezzeghoud.jaddiamar.free.fr/member.php?u=3167">cialis</a>
[URL=http://bezzeghoud.jaddiamar.free.fr/member.php?u=3167">http://bezzeghoud.jaddiamar.free.fr/member.php?u=3167]cialis[/URL]
http://bezzeghoud.jaddiamar.free.fr/member.php?u=3167">http://bezzeghoud.jaddiamar.free.fr/member.php?u=3167

# viagra

Friday, August 22, 2008 4:27 AM by viagra
Beautiful site!
<a href="http://www.pfv-berlin.de/forum/member.php?u=10925">http://www.pfv-berlin.de/forum/member.php?u=10925">viagra</a>">http://www.pfv-berlin.de/forum/member.php?u=10925">http://www.pfv-berlin.de/forum/member.php?u=10925">viagra</a>
[URL=http://www.pfv-berlin.de/forum/member.php?u=10925">http://www.pfv-berlin.de/forum/member.php?u=10925]viagra[/URL]
http://www.pfv-berlin.de/forum/member.php?u=10925">http://www.pfv-berlin.de/forum/member.php?u=10925
<a href="http://www.actiontrack.org.uk/actionchat/member.php?u=574">http://www.actiontrack.org.uk/actionchat/member.php?u=574">cialis</a>">http://www.actiontrack.org.uk/actionchat/member.php?u=574">http://www.actiontrack.org.uk/actionchat/member.php?u=574">cialis</a>
[URL=http://www.actiontrack.org.uk/actionchat/member.php?u=574">http://www.actiontrack.org.uk/actionchat/member.php?u=574]cialis[/URL]
http://www.actiontrack.org.uk/actionchat/member.php?u=574">http://www.actiontrack.org.uk/actionchat/member.php?u=574
<a href="http://finalfantasyrpg.pytalhost.de/upload/member.php?u=2492">http://finalfantasyrpg.pytalhost.de/upload/member.php?u=2492">cialis</a>">http://finalfantasyrpg.pytalhost.de/upload/member.php?u=2492">http://finalfantasyrpg.pytalhost.de/upload/member.php?u=2492">cialis</a>
[URL=http://finalfantasyrpg.pytalhost.de/upload/member.php?u=2492">http://finalfantasyrpg.pytalhost.de/upload/member.php?u=2492]cialis[/URL]
http://finalfantasyrpg.pytalhost.de/upload/member.php?u=2492">http://finalfantasyrpg.pytalhost.de/upload/member.php?u=2492
<a href="http://www.newbusinessportal.co.uk/forum/member.php?u=2742">http://www.newbusinessportal.co.uk/forum/member.php?u=2742">viagra</a>">http://www.newbusinessportal.co.uk/forum/member.php?u=2742">http://www.newbusinessportal.co.uk/forum/member.php?u=2742">viagra</a>
[URL=http://www.newbusinessportal.co.uk/forum/member.php?u=2742">http://www.newbusinessportal.co.uk/forum/member.php?u=2742]viagra[/URL]
http://www.newbusinessportal.co.uk/forum/member.php?u=2742">http://www.newbusinessportal.co.uk/forum/member.php?u=2742