Importing Validation

Question

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

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

lrosales SSCommitted Points: 1821 More actions · Answer 1

Guys

All Issues where resolved. here the answer was to use a non documented store procedure called xp_FileExist and catch the reurtn code.

exec xp_fileexit 'c:\tst.txt', @catchcode Output

if the @catchcode = 1

Print ''file has arrived.'

else

Print 'No file is here yet.'

you know the general idea.

thanks:hehe:

"We never plan to Fail, We just fail to plan":)

CrazyMan SSChampion Points: 12560 More actions · Answer 2

just out of curiosity, which version has got this XP, i cant see this on SQL 2005 😀

lrosales SSCommitted Points: 1821 More actions · Answer 3

Found it on SQL 2000

"We never plan to Fail, We just fail to plan":)

Ron McCullough SSC Guru Points: 63877 More actions · Answer 4

xp_FileExist and catch the reurtn code.
exec xp_fileexit 'c:\tst.txt', @catchcode Output

Watch the spelling in the exec line it is misspelled. It does exist in my SQL 2005.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

lrosales SSCommitted Points: 1821 More actions · Answer 5

Thanks for the Correction, Please understand I was very busy at the time. thx:w00t:

"We never plan to Fail, We just fail to plan":)