Try to run bulk insert from a stored procedure

Apr 25 2019 2:26 AM

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?

Answers (1)