Huh? I hope you're thinking about a different Jet than I'm thinking about.

mrani.soukaina (9/9/2015)

---

Thank you for ur answer Alvin, i tried the delay option before and it didn't work, still getting the same error...

i thought maybe it's something related to the package...

Chances are the issue is due to your package processing files faster than Windows can release the file after processing. I've had that problem many times.

You could try adding...

Ooops! Missed the lack of clustered index.

For how many records?

Brandie Tarvin (9/8/2015)

---

Grant Fritchey (9/8/2015)

---

Alvin Ramard (9/8/2015)

---

Steve Jones - SSC Editor (9/8/2015)

---

Jeff Moden (9/3/2015)

---

Alvin Ramard (9/3/2015)

---

Grant Fritchey (9/3/2015)

---

Another funny one today. Provided a DMV and a link to the documentation....

oneteabag (9/8/2015)

---

Hi all,

I have the following scenario and looking for some advise:

SQL database on SQL 2012

Large Production table 15 Million record

The table has 3 years of data

New monthly data is...

You didn't answer my question!

You probably have a usable package loaded, but how should I know if you won't answer?

Take a look at what got loaded.

Does the package(s) appear in the solution explorer?

Steve Jones - SSC Editor (9/8/2015)

---

Jeff Moden (9/3/2015)

---

Alvin Ramard (9/3/2015)

---

Grant Fritchey (9/3/2015)

---

Another funny one today. Provided a DMV and a link to the documentation. I was asked "Is that real?"

Nope....

Source of the error?

I've had the same issue when loading packages created by others and they ran fine when I ran them.

Chances are, the only thing that you might have to fix is...

Maybe somebody said this already and I missed it, but don't forget that "field IS NULL" and "ISNULL(field,0) =0" are not the same thing.

"field IS NULL" will not return records...

Looking at ... "(Object reference not set to an instance of an object.)" ...

I would reconfigure every item in the package, especially the section where you select the database(s)....

John Mitchell-245523 (9/8/2015)

---

If it's an option for you, concentrate on cleaning the data. You're always going to find edge cases that you hadn't accounted for - maybe the two...