miles411 (1/16/2013)

---

I am using SQL 2008 server and an external vendor changed the particular warehouse name for the IMPORT file that I was receiving through my SQL server from them. I get an error under the SQL Server Agent stating the IMPORTFROMXXX has failed. When I open the Job that is running notice that the warehouse name under the import file script is incorrect when I change it to the new name it still fails. How do I go about correcting this? Is there same place I should be typing credentials somewhere within my SQL server so the warehouse date outside my network know who I am?

I have attached some screen shots of my issue.

Thank you,

miles411 (1/16/2013)

---

Our outside vendor changed the name the of what the database warehouse was called recently and since then my users with Access that is link to our internal SQL database cannot pull the required information. I believe the name is embedded under the step dialogue box. It is a Transact-SQL script (T-SQL) type step. Under the command box is state drop table select*into XXX_XX_XXXXXX from XXX_XXXX_XXview.dbo.wh_employees.

miles411 (1/16/2013)

---

It stated: "Quit the job reporting failure"