I have this command in a declared variable in my stored procdure:
bulk insert av_file1 from 'C:\PopulationUpdate\A20101214_210003.out' with (codepage = 'ACP', formatfile = 'C:\PopulationUpdate\PUP.fmt')
When I execute the stored procedure I receive this error:
Database 'bulk insert av_file1 from 'C:\PopulationUpdate\A20101214_210003' does not exist. Make sure that the name is entered correctly.
Note: that the extension on my filename has disappered.
Why?
Solution?