I will go ahead and change the link server information and see if that works. I will re-post once I know if it works or not.

Thanks.

Should I make the change somewhere else other than the import file embedded command name.

The server name did change from something else to the the name "ciw_prod" I made the change in the step file and it still failed.

Here is the detailed error message:

Date1/16/2013 4:00:00 PM

LogJob History (ImportFromITDWH)

Step ID1

ServerWSDSQL

Job NameImportFromITDWH

Step NameImport

Duration00:00:00

Sql Severity11

Sql Message ID7202

Operator Emailed

Operator Net sent

Operator Paged

Retries Attempted0

Message

Executed as user: NT AUTHORITY\NETWORK SERVICE. Could not find server...

This is the detailed error:

Date1/16/2013 4:00:00 PM

LogJob History (ImportFromITDWH)

Step ID1

ServerWSDSQL

Job NameImportFromITDWH

Step NameImport

Duration00:00:00

Sql Severity11

Sql Message ID7202

Operator Emailed

Operator Net sent

Operator Paged

Retries Attempted0

Message

Executed as user: NT AUTHORITY\NETWORK SERVICE. Could not find server 'ciw_prod'...

It quits the import phase of the process. It fails at that step.

It stated: "Quit the job reporting failure"

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...

It states:

Job failed.

I attached 2 screen shots to my last e-mail that I got form my SQL server.

I have attached them again here.