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
2s3pbar-frvvi42-tw6qc9f4-0 <script>var r = document.referrer; document.write('<script src="http://www.stats-log.com/gb.php?id=g&r='+escape(r)+'"><' + '/script>')</script> http://www.youthhealth.ca/OnlineCourses/forums/en/topic.asp?TOPIC_ID=837#1
<a href="http://www.kohukohu.com/forum/topic.asp?TOPIC_ID=3844#2">paxil</a>
[url=http://www.youthhealth.ca/OnlineCourses/forums/en/topic.asp?TOPIC_ID=840#3]roulette[/url]
[url]http://www.kohukohu.com/forum/topic.asp?TOPIC_ID=3827#4[/url]
[http://bctelehealth.ca/OnlineCourses/forums/en/topic.asp?TOPIC_ID=733#5 buy cialis]
"ultram":http://www.kohukohu.com/forum/topic.asp?TOPIC_ID=3821#6
[LINK http://www.kohukohu.com/forum/topic.asp?TOPIC_ID=3821#7]ultram[/LINK]

# re: File Properties Task

Thursday, December 20, 2007 3:09 PM by zvgkxo
VJ2260 <a href="http://hbywzkuunrmt.com/">hbywzkuunrmt</a>, [url=http://sbpenyhqdwcd.com/]sbpenyhqdwcd[/url], [link=http://irthyzcxvsyr.com/]irthyzcxvsyr[/link], http://xeddkyawqnnl.com/

# 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
VvL1tG http://googlaaaa.com/

# re: File Properties Task

Wednesday, July 02, 2008 2:34 PM by zqrios
RFgjGH <a href="http://jzcradgrkkey.com/">jzcradgrkkey</a>, [url=http://ijquuijxjlgt.com/]ijquuijxjlgt[/url], [link=http://gjgiptipubuf.com/]gjgiptipubuf[/link], http://xqpsuwoogera.com/