Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dtong004
Constraint Violating Yak Guru
281 Posts |
 Posted - 2001-07-02 : 12:28:22
|
| The SQL server was set up to download a file exists in a Unix server. This job was scheduled daily. I setup with xp_cmdshell 'ftp xxxxxx' and I use sql angent to schedule the job. and Rest procdure is to BCP it in. It went pretty slick till sometimes the file over unix side is not ready at the time I schedule to ftp. The bad thing is that SQL server won't return erro if the file not exist over unix side. And ftp will create the file with 0 size. Question: How to let my SQL know if a file exist over the unix side. If exists, return something, if not, return something else. Thanks in advance. Daniel |
|
|
|
|
|
Auto imports with SQL server.