Sounds like a data type conversion issue. Is the data you're selecting of the same type as the table being inserted into?

Interesting! I thought running the script to "Allow In Process" would have fixed that - good to know when dealing with a web server 🙂

It can also be quite helpful to look at your cached execution plans to see which queries/procedures have inadequate query plans, this can be found by running the code belowSELECT...

I take that suggestion back!

Verify these things are true:

1. Install Office 2007 Data Connectivity Components (http://www.microsoft.com/download/en/confirmation.aspx?id=23734) - which I'm sure is already installed as it currently works when runing as...

Oh ok, gotcha - very true, linked server not needed here...all I can suggest is that you need to verify that domain users have access to the file folder being...

Have you tried launching a new install of 2012, but only choose the Client Tools?

Um...no linked server? Are you certain? I am under the impression you can't import data from EXCEL without using a linked server or some System DSN (which then...

As BitBucket has stated, it's a challenge to assume what you want without the basics needed for everyone to give it a whirl. Not sure if the example below...

You also may wish to check out these links:

http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/b41cc278-87e8-44a2-b7c3-12ef603cb964

http://stackoverflow.com/questions/9687631/openrowset-with-excel-file

And also make sure the file isn't currently open while running your process, this error can pop up if the file is...

Check the security settings for the linked server. Is security set to "without security context", ""login's current security context", or "this...

Scott, for the record I agree with what you're saying (really, I do), just wanted to provide an option to what the OP originally requested. To fulfill his/her initial...

And Yes, changing the job name itself would still cause an issue, however hopefully changes like that would be made by a DBA or otherwise communicated that a change was...

Of course, could happen 😀 One should takes measures to avoid that...I'd create a function to look up the job_id based upon the job name (that way no matter...

newdba_sql (1/25/2013)

---

Yeah... For somereason I was putting job name but not the job id......:w00t:

So this script will check if the job's last run status is successful, then it will move...

Please post the DDL for the "abc" table, and a few sample rows of data. Most likely it's just a matter of a missing row terminator or something similar...