[cfaussie] RE: CF to quick!

Tue, 20 Jan 2004 18:34:45 -0800

Title: Message
The file exist thingy won't work, as the file will exist but just not full of exported data yet;-))
 
I'm sure I'll get there ;-))
 

Taco Fleur
07 3535 5072
Blog: http://www.tacofleur.com/index/blog/
Methodology: http://www.tacofleur.com/index/methodology/
Tell me and I will forget
Show me and I will remember
Teach me and I will learn

-----Original Message-----
From: Nick Gorst [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 21 January 2004 10:48 AM
To: CFAussie Mailing List
Subject: [cfaussie] RE: CF to quick!

It may still be possible using the same principles. There are a surprising number of undocumented Stored procedures and extended stored procedures. I'm not sure any will do the same thing but you should check
 
http://www.sqlservercentral.com/default.asp
 
One alternative is to do a check for the file this can be done from SQL Server 2000 the following comes from the above site you should also check http://www.sqldts.com/
 

xp_fileexist


You can use this extended stored procedure to determine whether the
particular file exists on the disk or not.

Syntax:

EXECUTE xp_fileexist filename [, file_exists INT OUTPUT]


To check whether the file boot.ini exists on the disk c: or not, run:

EXEC master..xp_fileexist 'c:\boot.ini'


Here is the result set from my machine:

File Exists File is a Directory Parent Directory Exists
----------- ------------------- -----------------------
1           0                   1

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco Fleur
Sent: Wednesday, 21 January 2004 10:20 AM
To: CFAussie Mailing List
Subject: [cfaussie] RE: CF to quick!

I realize that, but I like my DTS packages portable, if I can't find another solution I will have to go that way.
 
Thanks Nick..
 
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004

Reply via email to