SQL Server Performance Forum – Threads Archive
If statement problemI am converting one of our sql 2000 machines over to sql 2005 and found that one of my import scripts is now blowing up. It looks something like this: if (select filename from db..table
where filename = ‘file.dat’) = ‘file.dat’
bulk insert file
end It is blowing up on the bulk insert because the file doesn’t exist making that not a valid sql statement. The problem is that once a file arrives to us, it is a valid statement and thus works fine. It worked fine in sql 2000. Is there a setting that I’m missing or is it just not going to allow my sloppy coding any longer? Greg
if exists (select *from db..table
where filename = ‘file.dat’) But that won’t help the error. bulk insert still doesn’t check for the existance of external files before executing so I doubt if that is the problem. Is the path you are using valud on the v2005 server? Instead of using a table to check for the existance of the file why not just check the folder to see what is there?
Nigel, it is nice to see you here [<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
Yes, indeed! <br /><br />…but apparently his autosig didn’t make it from SQLTeam to here. [<img src=’/community/emoticons/emotion-5.gif’ alt=’‘ />]<br /><br />–<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />Ich unterstuetze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)
I’ll get round to it.
At a company which is a bit restrictive on internet access at the moment. Can’t get to hotmail or anything that needs passport.
Snitz seems to be ok though.