Hi, I have a SSIS 2005 job that imports data from a text file that is on a network share (from a Linux server). Processing the job in SSIS is fine. However when I create a scheduled job in SQL it fails. I have tried using a mapped network drive, the full UNC, running the SQL Agent as a domain user but nothing works. Error message when using the mapped network drive is "cannot open the datafile...". Using the UNC the error msg is "the file name specified in the connection is not valid". The Linux share is open as read only to all users. Any ideas??
SQL Jobs authenticate using the account that SQL SERVER AGENT is running under. The fact that you are trying to access the file on a Linux server is what I am unsure of. I would suggest creating the user on your linux server that your SQL SERVER AGENT account is running under and give that user rights to the share.