I am trying to create a stored procedure to import data from a text file on a periodic basis into a table. The text file is generated monthly and has the month and year as part of the file name (e.g. 2003-10-01.dat). The text file resides on a network drive.
Is there a way to import this data using the BULK INSERT command? I have tried several variants but I am not successful when trying to run my stored procedure against the text file on the network drive. I get an 'Operating system error code 5(Access is denied.)' error.
What settings/security permissions (and where do I find those settings) do I need to check to provide sufficient access?
Also, is this task better done through a DTS package?